Hello,

Consider the situation below.
Two tables (A & B), in two environments (DEV & TEST), with records in those tables.
If you look the content of the tables, you understand that functionnal data are identical.
I mean except the PK and FK values, the name Roger is sill connected to Fruit & Vegetable.

In DEV environment :

Table A
1 Roger
2 Kevin

Table B (italic field is FK to table A)
1 1 Fruit
2 1 Vegetable
3 2 Meat

In TEST environment :

Table A
4 Roger
5 Kevin

Table B (italic field is FK to table A)
7 4 Fruit
8 4 Vegetable
9 5 Meat

I'm looking for a SQL Data Compare tool which will tell me there is no difference in the above case.
Or if there is, it will generate insert & update scripts with the right order (insert first in A then B)

Thanks a lot guys,

Grégoire