SchemaVersion simplifies SQL development by enabling users to store database schema in file-based version control systems. The tool allows the user to download schema files and add them to any chosen version control system.
SchemaVersion is a SQL development tool that enables simple and efficient storage of a SQL database schema in any file-based version control system like Mercurial, Git, or SourceSafe. This tool allows you to quickly download your database schema into files and place them under the version control system that you prefer.
With SchemaVersion, you can easily download various components of your database schema such as tables, triggers, views, functions, and stored procedures, with just a few clicks. It also tracks any changes made to your schema files to ensure accurate version control.
Another useful feature of SchemaVersion is its ability to generate update scripts with just one click. However, it is important to note that there are a few limitations with this tool. Currently, pushing a table to the server is not possible; you will have to script the table, modify the script, and then run it on the server.
Additionally, server validation of stored procedures and functions may result in false positives, which could affect the accuracy of your database schema. We have tested SchemaVersion on Windows 7 with MS SQL Server 2008 R2 only. However, we welcome any feedback related to other versions of Windows / SQL Server.
Overall, SchemaVersion is an excellent tool for SQL developers looking for efficient schema version control in file-based version control systems.
With SchemaVersion, you can easily download various components of your database schema such as tables, triggers, views, functions, and stored procedures, with just a few clicks. It also tracks any changes made to your schema files to ensure accurate version control.
Another useful feature of SchemaVersion is its ability to generate update scripts with just one click. However, it is important to note that there are a few limitations with this tool. Currently, pushing a table to the server is not possible; you will have to script the table, modify the script, and then run it on the server.
Additionally, server validation of stored procedures and functions may result in false positives, which could affect the accuracy of your database schema. We have tested SchemaVersion on Windows 7 with MS SQL Server 2008 R2 only. However, we welcome any feedback related to other versions of Windows / SQL Server.
Overall, SchemaVersion is an excellent tool for SQL developers looking for efficient schema version control in file-based version control systems.
What's New
Version 0.9.5402.25223:
New result filter: allows to filter by server object type or hide unchanged objects.
Lowered requirements to .NET 2.0