DB SynchroComp compares two SQL Server (7 - 2005) databases, determines differences between them, and generates the script that will change the target database structure to match the source database structure. After you execute the synchronization script, two databases will have the same structure, and existing data in the target database will remain intact.
Database differences will be shown graphically and textually. It is possible to select the objects that are to be synchronized or to synchronize all the objects (this is the default option). You can change some of the comparison options before the comparison of databases. After creating the synchronization script, it will be possible to change it. But usually, there will be no need to change this script.
DB SynchroComp changes the database structure only but not the data. After the synchronization of database schemas, the target tables will be populated with the data that existed on the target database before the synchronization, except for newly created fields that can be either null, or populated with some default data that are generated by the program or by the user.
Keywords: SQL, MS SQL, SQL 2005, Compare, Synchronize, Database, Collation, Structure, Script, Tool, Differences
|
Click to enlarge
|
Related programs in Business - Databases & Tools |
TimeSync
TimeSync allows to adjust the clock of your Computer using the Internet.
|
PureSync
Easily synchronize, compare files and folders - with preview and automatic sync
|
DataTron
DataTron is an easy-to-use visual data base
|
Database Assistant
Manipulate data from a variety of databases including Oracle, SQL Server, et al
|
SyncFolder
The fast way to compare and merge your files and folders
|
SynchroPass
Windows Network Passwords Synchronizer
|
DbFacePHP
MySQL web interface, PHP application builder and sql reporting tool.
|
FastSum
An extremely fast utility for your files integrity control.
|
SP Dialer
Advanced Internet dialer, PC clock synchronizer and proxy server.
|
odbc2csv
odbc2csv ODBC DSN information from the command line to csv
|