Merge vs. Synchronize database

romrom72romrom72 Posts: 2
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
Tagged:

Comments

Sign In or Register to comment.