DBSourceTools

  • Rating:
  • Version: 1.3.0.0 Beta
  • Publisher:
    dbsourcetools.codeplex.com
  • File Size: 7.67 MB
  • Date: Feb 23, 2011
  • License: Free
  • Category:
    Database Management
    Business & Finance
DBSourceTools Download
Free Download DBSourceTools 1.3.0.0 Beta

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 Management Studio. SQL Server databases under source control.

Create a new project
1. Fire up DBSourceTools, and click File | New | Project.
2. Enter a Project Name, and a Base Directory.
* Note that this will create the <Project> directory, as well as a <Project>.dbsp file, and a <Project>.xml file in the base directory.
3. Click on the Database Button.
4. Specify a NickName for the database ( this can be anything you like), but I prefer Template_<DatabaseName>
5. Specify connection settings
* Note that these connection settings will be stored in <Project>.xml
6. Click "Test Connection"
7. Once the connection has succeeded, click OK.
8. You will be prompted to load the database.
9. Once all objects have been loaded from the database, the DBExplorer tree will be populated.

DBSourceTools Features:
* 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

The license of this software is Free, you can free download and free use this database management software.

More Details:
Related Software: