Advanced SQL Data Compare throught multiple tables
- by podosta
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
