Merge vs. Synchronize database

romrom72

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

Anu D

Thanks for your post!

I have logged a support ticket for you and will email you shortly!

ckaeser

Hey! I have the same issue and couldn't find the solution for it.

Tianjiao_Li

Hi @ckaeser ,

At present you can achieve this by going into comparison results and for each table selecting the columns manually.

If you wish to have this automated, can you please kindly leave a suggestion on our user voice forum so that other people can vote for it.