Migration data with foreign key defined

Dec 18, 2009 at 8:51 PM

Hi,

I have one question regarding migrate data from sql server 2008 R2 to sql azure. So the new version now can migrate data in teh tables as well but I wonder if tables have foreign keys defined among them. Will this tool sort out the right order of the tables when populating data into sql azure. basically will it figure out the referential integratity automatically during the migration and have all the data moved to sql azure.

Thanks!

Dec 18, 2009 at 10:24 PM

Actually just tried with a database has foreign keys among tables and it worked very well. Great tool!

Coordinator
Dec 18, 2009 at 11:11 PM

Glad to hear that it works! Yes, I use SQL Server Management Objects to figure out dependencies on the tables so you should be good to go.

Regards,
George