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 |
|
dignam
Starting Member
4 Posts |
 Posted - 2007-05-22 : 12:03:00
|
| hi,Frustrating problem here! I need to import tables from one dB to another with primary keys and extended properties intact. In the old Enterprise Mgr this was easily done by selecting options. In 2005 I don't see how to do this with the Wizard. Can anyone send me tips for this or even a sample script that I can run to do this? We have several dBs with dozens of tables and manually adjusting them will be a nightmare. Many many thanks for any help!Jeffrey |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-22 : 12:25:02
|
| Have to use SSIS. |
 |
|
|
|
|
|
2005 Import Wzrd - How to import PK and ext props?