All Data to Target

DiggaDigga Posts: 20 Bronze 3
edited July 30, 2015 9:28AM in SQL Data Compare 11

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


  • 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
    Software Developer
    Redgate Software
Sign In or Register to comment.