How to avoid creating block inserts on synchronize script
How to avoid creating block inserts on synchronize script
I have a very large (600MB) Data Compare synchronize script result which is Inserting missing rows. Data Compare is generating the inserts in 200 row block inserts. There is the probability that many duplicate keys exists in the eventual target(s), so when the script is executed, the entire block fails. I need the comparison result sql script generated by Data Compare to create a single insert statement for every row. Is this possible, and how do I accomplish it? Or, how can I execute such a large script and force each row in the block to be evaluated (so if there was 1 duplicate the other 199 would still insert)? I've tried the command line execute for mysql with the --force option, but that option doesn't seem to work within a block, it's just allows the rest of the script to continue picking up at the next insert block.
Re: How to avoid creating block inserts on synchronize script
The value 200 can be changed in the 'Commit Page Length' field on the 'Options' page of the Data Synchronization wizard. Also, you can just unselect the 'Use Commit Mode' option.