SchemaVersion
SchemaVersion is an SQL development tool designed to help you store a SQL database schema in any file-based version control system (such as SourceSafe, Mercurial, Git, etc.) Simply download the schema into files and put them under the version control system of your choice.
System Requirements:
.NET 4.5
Has been tested to work on Windows 7 with MS SQL Server 2008 R2.
Notes:
Use on production servers at your own risk.
This is the first public release of this tool. We would appreciate any comments, bug reports, and feature requests.
Features:
- Easy and fast download of a database schema (tables, triggers, views, functions, stored procedures.)
- Tracking of schema file changes.
- One click generation of update scripts (see Limitations below.)
- Ability to upload changes directly to the database.
How To Use:
Hold your mouse over a toolbar button for a pop-up description.
Click on a column header to sort results.
If you specify a path for an editor and WinMerge in Tools->Options->Application, then double-clicking on the item will open the editor or WinMerge (if a file has changes.)
To generate an update script, select all the items you want to be included in the script and click the 'script to clipboard' button. The script header and footer from the project options page will be applied to the resulting script.
Limitations:
- At the moment it is not possible to push a table to the server. You need to script the table, modify script for your needs and run it on the server.
- Server validation of stored procedures and functions can give false positive.
- Tested on Windows 7 with MS SQL Server 2008 R2 only. We would appreciate any feedback regarding other versions of Windows/Sql Server.
Screenshots:
SchemaVersion
Project Settings
Application Settings