How to avoid creating block inserts on synchronize script
Posted: Thu 08 May 2014 18:00
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.