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

All Data to Target

Hi

Can SQL Data Compare push all data from source to target?

I would like the target data to be exactly the same as the source data when finished including reseeding, just as if I've restored the database from a backup.

Many thanks
Digga
0

Comments

1 comment

Sort by
  • sam.blackburn
    Yes, Compare and Data Compare can do this.

    You could deploy any schema changes (e.g. extra columns in a table) using Compare and then deploy data changes using Data Compare. If you just want to restore a previous database state then a backup is often a quicker way to do it, although that is troublesome in some cases (moving to an older server, Azure, etc.)

    The main advantages of using Compare and Data Compare come into play when you need to do more than just restore a backup: you can see the differences before you deploy them, use filters to deploy only some of the data, use mappings to migrate data across schema changes, and so on.

    Hope this helps
    Sam Blackburn
    Developer, Red Gate Software
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.