Import Export wizard

Hello,

I am having alot of problems with the import export wizard. I am trying to copy over around 315 tables to a new database. When the tables are copied over to the new database they are copied without any of the original constraints. Does anyone know why this could be happening? What I am trying to accomplish is a simple database transfer with the exception of about 10 to 15 tables from the original database. I do not understand why this is such a problem. I did not create a package, as this is going to be a one time shot.

Any help would be appreciated.

Thanks,

David

My understanding is that its not supposed to copy constraints. The import wizard is all about moving data, not schema objects. Of course, if you're moving data into a database then it has to have somewhere to put it so in this case, yes, it creates some tables for you. If you want to do move other schema objects then the simple answer is to script them out in SSMS and run the scripts on the target server. This is alot easier in SQL2005 than it used to be because in SSMS you can now change the connection so you dont have to copy and paste between differernt windows.

-Jamie