What is the best way to migrate data from MS Access database to SQL Server 2005 database. If the migrationn done through Upsize Wizard in MS Access then it requires to remove the relationship first. Is there any way to migrate the data together the relationship.
