How can we help you today? How can we help you today?

Split update statements in batches or small sql files

Hi Team, Currently we are redgate sql data compare 14.2.22 version. We see that the maxtransactionsizeinMB option is not working. We are unable to split the records in to batches. We have a requirement to update 28 Million records. Tool is providing all update statements in a single batch which will cause huge blockings in our production. Please provide us a way to split into transactions or small .sql files.
bkarnati
0

Comments

2 comments

  • DanC
    Hi karnatibharathkumar

    Sorry to hear you're experiencing this issue!

    I can confirm that I did some extensive testing around this and raised it as a bug with the development team. They agreed it was a bug and there's a fix upcoming in the next release.

    I'll post another reply once it's out!
    DanC
    0
  • DanC
    HiĀ @karnatibharathkumar

    The bug has now been fixed in the latest release!
    DanC
    0

Add comment

Please sign in to leave a comment.