I have a similar issue, is there nothing to compare to mysql's wait_timeout or interactive_timeout ?

if your schema changes often, replication can be tedious.

8 million records is a lot to keep juggling around with any method but it sounds like bcp is the way to...