SQL Schema Tool Tool to generate/compare SQL schema from databases or serialized XML snapshot files
Download

SQL Schema Tool Ranking & Summary

SQL Schema Tool Tags

generate compare build process XSD Schema XML Schema Definition delta delta tools SQL query tool no sql facebook chat application latest biodata format wallpaper aquarium 3d sql builder tool sql autocomplete tool

SQL Schema Tool Description

The SQL Schema Tool or SST as it is now known started as a command-line developer’s 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. Give Sql Schema Tool a try to see what it's really capable of! Main features: Schema XML Snapshots, for portable SQL schema generation/compare without a database. Schema generation – with selectable object types. Schema compare – with selectable object types. DTS package XML Snapshots, for creating portable DTS packages. Two Command-line tools for the above listed functions. The command-line tools will allow ANT build or other build automation tools to compare or generate schema updates automatically. Data compare – for individual data tables at present. Data export – CVS and XLS, plan to add text file output for SQL insert statements. Reports for data compare, includes differences for all major SQL objects from the compared databases. XML tree browser with XPath search of XML snapshots generated by the tools. Run generated SQL against selected DB without switching to yet another tool. Logging of all events, actions and errors - both SQL related and application type errors. Custom User Defined XSLT transformations can be automatically applied to the generated SQL Schema and Data XML output.

SQL Schema Tool Related Software