How can we help you today? How can we help you today?

Migrating/Comparing data between two databases

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!
abjacs
0

Comments

1 comment

Sort by
  • peter.peart
    Hi there,

    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
    peter.peart
    0

Add comment

Please sign in to leave a comment.