The DBSourceTools application was designed to be a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.
Here are some key features of "DBSourceTools":
· Tested on SQL 2000, 2005, 2005 Express, 2008 Express, 2008 Dev Edition. (no support for SQL CE).
· One-click action to script a database to disk.
· Easily deploy a database through "Deployment Targets".
· Script from one version of SQL to another
· From 2000 to 2005 to 2008, or
· From 2008 to 2005.
· Verify database integrity during deployment.
· Automatically takes care of object dependencies.
· Automatically excludes computed columns on data load.
· Use the enhanced script-editor to edit tables / stored procedures / etc.
· Table and View Intellisense
· Search database scripts.
· Double-click to edit stored procedures and tables.
· Double-click to view table data.
· Dock / float windows
Requirements:
· SQL Server database
What's New in This Release: [ read full changelog ]
· Fixed DateTime bug in Excel import.
· Added Server Explorer ( just shows databases on server ).
· Fixed bug when opening invalid project files.