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 |
|
Karna
Starting Member
4 Posts |
 Posted - 2007-06-01 : 01:04:24
|
| Hi all, From SQL Server 2000 Import wizard if we use Copy Objects & data between SQL Server Databases it'll copies tables with primary key. Similar to this what is the alternative method in SQL Server 2005.Please suggest me to solve the problemThanks in advanceKarna |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-06-01 : 04:18:21
|
| Use the Transfer SQL Server Objects Task. Not sure if there's a wizard for this though...Mark |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-02 : 00:31:56
|
| Not in import/export wizard, is ssis task. |
|
|
|
|
|
|
Importing objects between SQL Server Databases