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
· Share on Twitter

Comments

  • Options
    Chris AucklandChris Auckland Posts: 769
    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
    · Share on Twitter
Sign In or Register to comment.