I'm syncing data between a dev and production mysql db using dbForge's data compare tool, which is great, except the table has 1.7m records and it's sync'ing one record at a time. This thing will take weeks to finish. Is there a faster way to do this? Can I truncate the production table first and so it can do bulk inserts or something? 

Currently I'm looking for a better tool to do this, but I'd like to keep using dbForge's tool as it's pretty nice otherwise.