Hi,

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
masterbaker
0

Comments

5 comments

  • masterbaker
    any ideas? thanks
    masterbaker
    0
  • Chris Auckland
    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.
    Chris Auckland
    0
  • masterbaker
    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
    masterbaker
    0
  • Chris Auckland
    That's right. As soon as the internet connection is lost, the sync' will fail and rollback.
    Chris Auckland
    0
  • masterbaker
    thank you very much
    masterbaker
    0

Add comment

Please sign in to leave a comment.