Migrating/Comparing data between two databases
abjacs
Posts: 11
Let's assume the case where I migrate the data from one table in a database to another table in a different database. The name of the table is Users.
The schema of the Users table is identical between the two databases, except that in one database the Users table has an extra column named age.
From my experience with SqlData Compare, data migration will still execute successfully between these two tables, but only for all matching schema that these tables share.
Can you please verify this?
Thanks!
The schema of the Users table is identical between the two databases, except that in one database the Users table has an extra column named age.
From my experience with SqlData Compare, data migration will still execute successfully between these two tables, but only for all matching schema that these tables share.
Can you please verify this?
Thanks!
Comments
As far as I am aware, SQL Data Compare will map up the tables it can, and when you have additional columns it will just exclude them from the comparison and synchronization, as it cant include anything that it can't map.
Therefore, you are correct from your experience.
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569