DBSourceTools is 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
Current Release : 220.127.116.11
- Changed TextEditor from FireEdit to ICSharpCode.TextEditor
- Highlight both field and table names in scripts ( in blue ) - see screenshot below
- 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 (nickt_ch)
- Fixed comment / uncomment (tareq)
To view release history, go here
Help needed testing and updating Intellisense.
While every effort has been made to correctly suggest Intellisense options, I feel that there are a lot more cases that I should be checking for.
If you find that Intellisense is not working for you correclty, please could you send me a sample sql script that I can plug in to the Intellisense engine.
Better yet, send me a patch.
Have a look at the tests in TestICSharpCode.MSSQLExtensions for some Intellisense samples.
Where in the world are you ?
Find out where DBSourceTools is used, or show us where you are :
Quick Start Guide
Using Source Code Control
Don't use a DEV database server
Too often, developers use a central "dev" database during development.
This leads to any number of frustrating problems:
Use a Local database copy
- Developers break each others code.
- Developers get frustrated when someone else breaks their code.
- Development time is slow.
- There is no version control over database objects and scripts.
Here's how to alleviate these problems:
- Give each developer their own local version of the database.
- Script all database objects to disk, and place them under version control.
- Easily get the latest version, and re-create your local database.
- Microsoft SQL Server Management Studio (2005) has a very limited script editor:
- No automatic begin / end section highlighting
- No collapsible regions
- No search facility
- You have to right-click and select "Script Object as " | "Create to" | "New query editor window" every time you want to edit an object.
- You have to remember to use ALTER or CREATE in your script when making changes.
Inspired by all of the above, as well as Microsoft's Visual Studio for Database Professionals, DBSourceTools was born:
- 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.
- Search database scripts.
- Double-click to edit stored procedures and tables.
- Double-click to view table data.
- Dock / float windows
Quick Start Guide