DOWNLOAD MDAC VERSION 6.1.7600.16385 UPDATE
DOWNLOAD MDAC VERSION 6.1.7600.16385 PORTABLE
DOWNLOAD MDAC VERSION 6.1.7600.16385 CODE

The code was written and tested against Microsoft SQL Server 2000 and SQL Server 2005. Therefore, I am writing this article and giving my code away under the attached license as well as any license used by the libraries contained within the code. I had decided to try and sell the software, but never seemed to generate much interest. The schema tool was then turned into a common set of classes that could be called from either a command line or a Winform GUI application.

DOWNLOAD MDAC VERSION 6.1.7600.16385 UPDATE

Additional code was added later to get schema changes made against development databases that did not exist in the QA databases and create update scripts to run against QA databases during the continuous build process. The SQL Schema Tool or SST started life as a command line project to get DTS packages out of the database as XML. Some of the design approaches used in SST come from my experiences with working in code base. I worked on the Querењњommander SQL Editor project at one point. Custom User Defined XSLT transformations can be automatically applied to the generated SQL Schema and Data XML output.Logging of all events, actions and errors - both SQL related and application type errors.Run generated SQL against selected DB without switching to yet another tool.XML tree browser with XPath search of XML snapshots generated by the tools.Reports for data compare, Schema tables, views, functions, and sprocs.Data export вЂ“ CVS and XLS, plan to add text file output for SQL insert statements.Data compare вЂ“ currently of individual tables only.This should allow ant build or other automation tools to compare or generate schema updates automatically. Two Command-line tools for the above listed functions.

DOWNLOAD MDAC VERSION 6.1.7600.16385 PORTABLE

DTS package XML Snapshots, for creating portable DTS packages.Schema compare вЂ“ with selectable object types.Schema generation вЂ“ with selectable object types.Schema XML snapshots, for portable SQL schema generation/compare without a database.This snapshot of the customer's database schema can then be compared to the current development database schema without requiring active connections and provide an update SQL script to run against the customer database.

My approach to the problem using SST, was to provide a way to capture the delivered customer's schema as an XML snapshot that describes the schema. However my experience with customers is that they are reluctant to have to swap out a production database for an entirely new one. One way that we can deliver schema changes for an existing database, is to create a new database with the updated schema and then use some ETL process to migrate data from the old database into the new one. This tool which I call the SQL Schema Tool or SST, was created to assist in handling the problems of comparing or providing update scripts that work against the issue of synchronizing a customer database schema from a previous version when migrating to a new version. I have worked on several projects, and every one had a different approach to ensuring that code and database schema stay in sync. It is not always easy to ensure that the previously delivered schema stays in sync with the code unless rigorous project process controls are in place. The challenge of developing code for any small or large development project that uses a SQL database, is that often the code and database schema change or get modified over the duration of the SDLC from what was previously delivered to the customer.

Download mdac version 6.1.7600.16385