Charlie’s path to dEAth

Buck Woody 在MSDN Blog上列出了他最中意的开源 SQL Server 工具软件，这些开源软件都是在微软的开源软件平台，CodePlex 上进行维护的。他介绍了五个软件。

1. Web版维护工具，SQLWebTools，http://www.codeplex.com/SQLWebTools。基于Web的SQL Server维护工具，可以用在远程主机上，代替企业管理器（企业管理器不是免费的）。还有一个Php版的工具phpMSAdmin，与之类似。
2. DBA经常要做的一件事，就是用脚本备份整个数据库结构。ScriptDB就是这样一个工具，http://www.codeplex.com/ScriptDB。这是一个用C#写成的命令行工具，可以将数据库结构以企业管理器中的层次结构备份到文件夹中。可以定期对数据库结构及其中的程序（存储过程、视图、函数、触发器等）做这样的快照，之后进行文本比较或者添加到版本管理工具中。

3. 

   数据库比较工具, DbDiff, http://www.codeplex.com/DbDiff。这种工具是非常有用的工具，可是在这之前我还没有找到过真正免费的。DbDiff只能比较数据库结构，不能比较数据。RedGate提供一系列的工具很强大，价格也公道。

4. SQL Server Express 管理工具,ExpressMaint, http://www.codeplex.com/ExpressMaint。SQL Server Express是免费的数据库服务器，有了各类辅助工具，就很值得一用。

5. 
   

   Simple SQL Server Dependencies, http://www.codeplex.com/SSSDependencies, 顾名思义，就是对SQL Server中的Object之间的关系进行分析的工具。

另外，在Del.icio.us中用sqlserver opensource tool这三个Tag ，可以发现下面的这些工具。Enjoy yourself.

1. SqlDump - MS SQL database backup program

   save this

   SqlDump is a program to backup a Microsoft SQL Server database as a text file. SqlDump generates SQL statements for tables, indexes, user-defined types, views, procedures, etc and also the table data.

   by atifaziz to sqlserver tool opensource free … saved by 16 other people … on oct 05

2. SourceForge.net: DB Designer Fork

   save this

   DB Designer Fork is a fork of the fabFORCE DBDesigner 4. DBDesigner is a visual database design system that integrates entity relationship design and database creation. DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.

   by gnagypal to database design opensource tool sqlserver … saved by 37 other people … on sept 02

3. SQuirreL SQL Client Home Page

   save this

   SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction. The minimum version of Java supported is 1.5.x as of SQuirreL vers

   by mnd to My OpenSource Database JDBC Visualization SQL Tool Java MySQL Oracle … saved by 438 other people … on may 30

4. Query Express

   save this

   “Simple Query Analyzer look-alike, especially useful for MSDE and SQL Express. Also connects to Oracle and other OLE-DB compliant databases. Packaged as a single 100KB executable, i.e. more than 300 times smaller than SQL Server Management Studio.”

   by rgedwards to sqlserver sql mssql msde tool windows freeware opensource … saved by 226 other people … on nov 16, 2006

5. Data Dictionary Creator

   save this

   Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it’s easier to keep the documentation in sync with the database as it changes.

   by atifaziz to opensource tool sqlserver … saved by 28 other people … on nov 16, 2006

6. Data Modelling Tools

   save this
   by martti to case comparison data database db design dev development directory free … saved by 339 other people … on oct 15, 2006

7. SQL Manager: Database Management Tools for MySQL, SQL Server, PostgreSQL, InterBase, Firebird

   save this

   Database maintenance tools for popular relational database servers.

   by markand1 to database maintenance tool tools sql manager sqlmanager.net ems mysql postgresql … saved by 210 other people … on oct 09, 2006

8. |QueryCommander the sql editor|

   save this

   QueryCommander is a free sql editor wrapped in a Visual Studio type of environment. QueryCommander supports:

   by radegast to sql sqlserver dotnet opensource tool … saved by 6 other people … on aug 01, 2006

9. SqlBI.eu

   save this
   by walkerh to database development freeware opensource sqlserver tool … saved by 12 other people … on july 17, 2006

10. SqlBulkTool 1.0

    save this

    SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of

    by walkerh to database development freeware opensource sqlserver tool … saved by 2 other people … on july 17, 2006

11. TSQLUnit testing framework

    save this
    by walkerh to agile database development framework opensource sqlserver testing tool … saved by 47 other people … on april 04, 2006

12. SchemaSpy

    save this

    Graphical Database Schema Metadata Browser

    by vercinger to database db2 db Mysql opensource PostgreSQL SQLServer sql tools tool … saved by 616 other people … on feb 06, 2006

Filed by charlie at 8:52 pm under DBA, Engineer, Tools