You need to find the differences
between two SQL databases? Or make them the same? This is
right tool for you! Easy to use, fast and reliable!
CompareDB can help you in the following situations:
find the differences between the development and production
databases
find the difference between two versions of you database
automize the upgrade procedure
double-check the database creation script
CompareDB compares and syncronizes the following database
objects:
Tables
View
Stored procedures
Functions
Triggers
Relationships between objects
CompareDB currently supports the following databases:
Microsoft SQL Server 2000
MSDE
Microsoft SQL Server 2005
Microsoft SQL Server 2005 express
How the database structure comparison work:
Specify the two databases to compare
Specify what type of objects to compare
CompareDB reads the structure of the two databases
CompareDB compares the structures and displays the results
How the syncronization procedure work:
Specify the direction of the syncronization (make the database
on the left side same as the one on the right side or vice
versa)
CompareDB generates the syncronization script and displays
it
You can choose to save the script or continue with the automatic
execution of the script
CompareDB either saves the script or automatically executes
it depending on you option.