by Byron Richard (1 Submission)
Category: Complete Applications
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(16 Votes)
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.
Inputs
Database server name, user name, and password
Assumes
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.
Download Database Synchronizer (62 KB)
VBcoders