What are the challenges you face when working across database platforms? Take the survey
Options

Backup before Synchronizing

mtranmtran Posts: 34
edited October 10, 2008 5:11AM in SQL Compare Previous Versions
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

Comments

  • Options
    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.
    Chris
Sign In or Register to comment.