What are the challenges you face when working across database platforms? Take the survey

Skip compare, migrate all rows

schammerschammer Posts: 4
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.

Sign In or Register to comment.