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 |
|
samsun125
Yak Posting Veteran
63 Posts |
 Posted - 2009-02-27 : 04:05:44
|
| I want to move tables,stored procedures and DTS packages from one sql server to other sql server.Both servers have sql server2000.Tell me the steps to follow.Please help me.Thanks in Advance. |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-02-27 : 04:15:38
|
| Backup and restore |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-02-27 : 04:18:53
|
| In enterprise manager there is a option for script sps and table structure port it in new serverusing linked server/open query instert the data from old to new |
|
|
|
samsun125
Yak Posting Veteran
63 Posts |
Posted - 2009-02-27 : 04:25:54
|
Can you just explain step by step to do the task.quote:
Originally posted by shaggy
In enterprise manager there is a option for script sps and table structure port it in new serverusing linked server/open query instert the data from old to new
|
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-02-27 : 05:16:36
|
| taking scripts for tables,sp's it is better to have a backfile and restore it on new database then u can get the tables& sp'sas shaggy first suggested |
|
|
|
xaviergdts
Starting Member
1 Post |
|
|
|
|
|
moving tables between 2 sql servers