Database Upsizing from MSDB to SQL
-
Hi all, Am trying to upsize certain tables from MSAccess database to SQL database.I have a preexisting database with tables which are vacant in SQL.While i try to upsize the database tables from MSAccess 2003 to SQL server am getting an error.I tried to upsize three tables out of which one was upsized fine with all data imported with out errors(was not having foreign key relations).But the other two are shooting errors and not upsizing . The error looks like " "Server Error 3726:"Couldnot drop object 'tablname' because it is referenced by a Foreign key constraint." I tried to remove all the foreign key connections in SQL tables and still getting the same error. Since am doing this for the first time,am unsure what exactly is the way to go? Any help will be welcome. Many Thanks,