what determines transaction size (split transactions)
I am using SQL Data Compare 18.104.22.168. When generating a synchronization script, I specified a 2 MB transaction size limit to generate split transactions. Because the database has a lot of binary data, the resulting script is 225 MB in size (on disk). I expected to see multiple begin-transaction and commit statements, but I only found one begin-transaction in the beginning and one commit at the end, bounding all SQL INSERT statements. What determines transaction size, as far as the split-transaction feature is concerned?
0 · Share on Twitter