All Data to Target

Digga

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

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