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 ]
· Changed TextEditor from FireEdit to ICSharpCode.TextEditor
· Highlight both field and table names in scripts
· Re-built Intellisense engine
· Intellisense now pops up while writing sql scripts
DBExplorer Updates:
· Added field dropdown on all tables and views in DBExplorer.
· Added data option for viewing data in Views.
Fixed reported bugs:
· Include Synonyms in scripting engine
· Fixed comment / uncomment