Skip compare, migrate all rows

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Skip compare, migrate all rows

Postby schammer » Thu Apr 26, 2012 5:37 pm

I would like to migrate data into an empty database with the same schema as the source. Since I know there will never be data in the destination, is there a way to skip the CompareDatabases() call and force the GetMigrationSQL() step to generate INSERT statements for all rows in the source database?

I ask because the CompareDatabases() call can take a long time on larger databases (20GB+), which seems unnecessary given that we know the destination is empty and there's nothing to compare to.

Thanks!
Brian
schammer
 
Posts: 2
Joined: Tue Jul 21, 2009 3:39 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests