Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-12-23 : 11:19:06
|
| Hey i copied over 50 of 70 tables to a new database using a import wizard DTS package and now i see it has created the tables that i did not select. Why does it or would it do this. If they were used in views or stored procedures would it import them also?.My problem is that i need to copy over the other 20 tables at the end of the year will the import wizard give me a problem or over write the tables i already copied over ? i see it given issues with users etc any advice would be great .. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 11:25:48
|
| Export/Import just copies data ,not constraints. It just copies what you specified and it's not smart enough to detect dependency. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-12-23 : 11:29:49
|
| ok, I i un ticked copy all object and selected select objects and tick each of the tables that i wanted but it has copied over a table that i did not tick.. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 11:45:38
|
| Are you sure about that?Never had that issue with it? Maybe destination database already has tables. Can you try with 5 tables first? |
|
|
|
|
|
|
copying a database objects to a new database