The SQL Schema Tool or SST as it is now known started as a command-line developers tool. As such, the tool was designed to assist developers working against a SQL server database, so as to migrate any database changes from a development environment into a test or nightly build environment.The SST is an application for generating XML schema documents from SQL server databases, comparing those databases or the XML schema documents, and finally generating a DiffGram XML document from the compare results. Simply put, the purpose is to make a snapshot of the current latest database schema and merge those changes into a build of the previous database schema (live or snapshot).The tool can make snapshots of databases, DTS packages, or even the data itself, to perform offline compare(s) and create update script(s). The tool can also be used to generate schema create scripts for archival or source control purposes. Version 220.127.116.11 fixes UI bugs related to document names, adds Data compare features.
What's new in this version:
Fixed several UI bugs related to document names. Added Data compare features. Now open source.