What are the challenges you face when working across database platforms? Take the survey

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.


Sign In or Register to comment.