Roll Back

masterbakermasterbaker Posts: 19

Recenly, we moved out pdn server to a data center, my question is, when doinf the sync, if internet drops, will everything gets rolled back? thanks


  • Options
    any ideas? thanks
  • Options
    Thanks for your post.

    By default, SQL Data compare 8 will put the whole script in a single transaction. This means if there is any problem during the execution of the script the whole script will be rolled back.

    You can customise this, so there are two alternatives if you do not want the script in a single transaction.

    1) Set the project option 'Don't use transactions in the synchronization script'

    2) You can also set the 'Application option' to 'Split transactions' over a certain size. This will result in multiple transactions, so the complete sync cannot be rolled back entirely.

    I hope this helps.
  • Options
    so if I leave it as default, if internet drops during process, PDN site will get rolled back, correct?

    Not sure if this question makes sense, at what point, it will get rolled back? right after internet drops? thanks
  • Options
    That's right. As soon as the internet connection is lost, the sync' will fail and rollback.
  • Options
    thank you very much
Sign In or Register to comment.