e-dule Software - Microsoft SQL Server Tools Microsoft SQL Developer or DBA
Home Product Support Download Company Affiliates Registration Contact  
FREE email newsletters

Free newsletter goes out approximately once every two months. We are very protective of your privacy
 

 

Compare and Synchronize Microsoft SQL Server Databases (Step 1)

1. Connecting to the databases - you select the source and target Microsoft SQL Server database

Connecting to the databases

 

The first step in the database synchronization is connecting to the SQL Server databases. When you run the DB SynchroComp, a connection dialog box will open, offering you to connect to the source and target databases. You can do this later, if you select Connect option from the menu. The source database is the database that is read-only in this case i.e. the one that has a preferred structure. The target database is the one that should be synchronized with the source database. You can connect to any MS SQL Server available on your network. From the list of available databases on the chosen server choose the SQL Server name first and than the database name. You have the ability to logically organize the servers into a tree list and thus easily manage your connections. DB SynchroComp will remember all your previous connections, so if you want, you can choose to do the comparison based on the parameters from the previous one. You must have the access rights for all the relevant database objects in both databases. If you don't have the right to create an object in the target database, you will not be able to select it in the list of database objects that are to be synchronized, nor will the script be created for that object.

 
Testimonials

"This tool for comparison and synchronization has a visual and easy-to-deal-with interface both at the stage of selecting databases to be compared and when viewing the comparison results. The software has a lot of options for comparing objects and a detailed visual help. Synchronization script is displayed in the separate window with the sql syntax highlighting; you can edit it before saving or executing."

Igor Shekalev
db-review.com
http://www.db-review.com

"DBSynchrocomp has saved me tons of development hours and remains the best product of this kind I know of."

Torsten Heinze
flexSCAPE, LLC
http://www.flexscape.com
USA

"We looked at the [NOTE: name removed] products, and yours is simpler, faster and runs the scripts, all round a much much better tool."

Nick Scales
Avecho
http://www.avecho.net
UK

"... and all compliments to DBSC, and to the author as well. I tried other tools, but I have not found any that can be used in professional environment."

Nikola Smirčić
NetLab

http://www.netlab.hr
Croatia

"Since our customer databases contain critical financial data we must be sure that no data are being lost when we are upgrading the database. I have tried a lot of different sql-sync programs, but my experience is that DBSC generates the safest script to preserve data, it is the most timesaving and has a simple user interface."

Tord Nilsen
Elfo AS

http://www.elfo.no
Norway

"This has been an invaluable tool to me while updating my beta sites. I am going through rapid development/release cycles that usually require extensive additions/modifications to the architecture of the database. It could sometimes take me hours to perform an update at a single site. DBSynchroComp has literally reduced this to minutes and I never have to worry about the accuracy of the results.The support is great as well. I highly recommend DBSyncroComp to anyone with a need to quickly and accurately synchronize db schema."

Jeff Baldwin
MenuXpress
USA