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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2008-08-04 : 10:59:01
|
| Hi ,I am trying to copy the objects from one server to another server,What is the best way to do that?? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-04 : 12:04:17
|
| Use Generate script task in task. |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-08-04 : 13:02:47
|
| I want to export all the data present in 2 tables.Generate scripts only create the tables,abt data? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-04 : 13:05:00
|
| Then apply scripts in destination server(which will pickup indexes and constraints as well). After that use Export/Import wizard to transfer data. You have to enable identity if it is used. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-08-04 : 13:08:22
|
| I want to use SSIS using "transfer sql server objects option",Is it a good way of doing? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-04 : 13:09:54
|
| Yes you can do it but why you want to waste time just only for 2 tables. From my personal experience, I have never been able to get what in desired from "transfer sql server objects option" in SSIS. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-08-04 : 13:29:38
|
| Thanks for ur advise Sodeep.I will do by import & export |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-04 : 23:31:21
|
| SSIS copy objects task works fine. |
|
|
|
|
|
|
Copying objects