LIONS BAY
CONSULTING

Software solutions for group insurance management.

CHOOSE YOUR TECHNOLOGY

We specialize in Database design and data merge/migration,

custom client management systems and providing technical expertise during acquisitions.

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.

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.

DOWNLOAD

Please be advised that this is a new product.
You might see “not commonly downloaded” warning in your browser

SCREENSHOTS

SchemaVersion SchemaVersion
ProjectSettings ProjectSettings
ApplicationSettings ApplicationSettings

EMAIL
support@LionsBayConsulting.com

--

--

  • --