Split update statements in batches or small sql files

karnatibharathkumar

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.

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

Hi @karnatibharathkumar

The bug has now been fixed in the latest release!