Backup before Synchronizing

mtran

Is there a command for backing up the database before synchronizing? Is the Database.SaveToDisk method the same as right clicking the database and creating a backup file?

Thanks

Chris Auckland

Thanks for your post.

SQL Compare UI and the SQL Compare API do not have a backup before sync' option.

Database.SavetoDisk will enable you to create a snapshot of the schema, but it will not contain any data.

If you want to perform a backup before you do anything using the API, you could use the BackupCommand Methods of the RedGate.BackupReader namespace (see SQL Data Compare API help).

I hope this is helpful.