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?
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).
Comments
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.