SchemaVersion

SchemaVersion, developed by Lions Bay Consulting Inc., is a powerful SQL development tool coming with the latest version 0.9.5402.2 and primarily supporting "Windows 7, 10, and 11". This tool falls under the category of Development Tools and is specifically listed under Database Tools.

SchemaVersion facilitates the management of a SQL database schema by enabling users to store the schema in any file-based version control system such as SourceSafe, Mercurial, or Git. It features a highly efficient process to download the database schema (including tables, triggers, views, functions, stored procedures) and track any changes made to schema files. The process is seamless; with one-click generation of update scripts, users save considerable time in database management. However, it's important to note that uploading changes directly to the database is also effortless with SchemaVersion.

While SchemaVersion excels in most areas, there are some limitations to be aware of. Currently, pushing a table to the server isn't automated; users have to script the table, adjust the script as needed, and run it manually on the server. Additionally, server validation of stored procedures and functions might sometimes provide false positives.

It's noteworthy that SchemaVersion has been tested on Windows 7 and MS SQL Server 2008 R2, with feedback actively sought for experiences on different versions of Windows and SQL Server. The program file names for this utility are SchemaVersion.exe, and while the latest version out now is 0.9.5402.2, previous versions such as 0.9 are also available.

Pros:

• Free download and easy setup.
• Efficient tracking of schema file changes.
• One-click generation of update scripts.
• Direct upload of changes to the database.

Cons:

• Scripted manual intervention needed for tables.
• Potential for false positives in server validation.
• Limited testing on various Windows and SQL Server versions.

For anyone involved in SQL development and seeking a tool to streamline schema storage in version control systems, SchemaVersion offers robust functionalities with some minor limitations.

You may want to check out more software, such as ThinkWave Educator, DBScribe for MySQL or Mybase, which might be related to SchemaVersion.