Merge vs. Synchronize database

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Merge vs. Synchronize database

Postby romrom72 » Mon Jun 16, 2014 10:28 pm

I recently downloaded a trial of "SQL Data Compare" hoping it would merge two databases having the same schema.
However it seems to me that the deployment is merely copying rows from tables found in source DB that are absent in destination DB tables, modifying the destination tables (via UPDATE statements) to make them identical to the source tables and deleting all rows found in the destination tables that are absent in source tables.
What I really want is a full merge of all relevant tables in both databases and for the foreign keys to be adjusted accordingly. This is how I understand a true merge and I thought that was the function of the synchronization feature. Am I asking for too much?

Example:

Source DB:

PK Rank Description
1 Private
2 Corporal
3 Sergeant


ID Name Rank
54 Joe 1
60 Frank 1
63 Robert 3


Destination DB:


PK Rank Description
3 Private
4 Corporal
5 Sargaent
7 Lieutenant


ID Name Rank
45 Steve 3
67 Max 3
78 Tom 5
80 Peter 7


Merged (Target) DB:


PK Rank Description
1 Private
2 Corporal
3 Sergeant
4 Lieutenant


ID Name Rank
1 Joe 1
2 Frank 1
3 Robert 3
4 Steve 1
5 Max 1
6 Tom 3
7 Peter 4
romrom72
 
Posts: 1
Joined: Mon Jun 16, 2014 8:21 pm

Postby Anu Deshpande » Tue Jun 17, 2014 10:01 am

Thanks for your post!

I have logged a support ticket for you and will email you shortly!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests