Database Synchronizer

This software lists the differences in tables, fields, indexes, stored procedures, views, constraints, keys, and triggers, between two databases. You can specify one to be a master and one a slave, then synchronize the slave to the master (using the SQLDMO), or create a SQL script to do the synch. You can toggle whether to "Fix" a difference or Xfer data by clicking on that cell. You can double-click on the "Slave" cell to run Windiff and view the difference between the SQL creation scripts.

Original Author: Byron Richard

Inputs

Database server name, user name, and password

Assumptions

In order to use the view the differences between the SQL creation scripts for a particular item, you will need to make sure the files Windiff.exe and GUTILS.DLL are copied to your App.Path.

Side Effects

The software currently cannot change a field's datatype, and the Bulk Copy option for data is buggy. There is the framework for being able to diff data in two tables, but it is specific to the task I was working on.

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 84 times

Comments

No comments have been added for this post.

You must be logged in to make a comment.