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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2003-03-12 : 07:38:05
|
| Where could i find an article on moving a database from one server to another?thanksmb |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-12 : 09:14:10
|
| http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_89pv.aspJay White{0} |
 |
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-03-12 : 10:33:30
|
| I want to say something regarding ur requirement.a) If u have both databases is in same server, u can transfer database using DTS package.b) If ur databases are diffrent servers, try to create Linked server, and transfer ur data from one server to another.c) Another way is "Detaching" and "Attaching" the database method.IT Knowledge is power |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-12 : 11:08:24
|
| SqlStar,Why do you say both DBs have to be on the same server to use DTS?-Chad |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-12 : 11:18:53
|
And why can't you spell out "you" and "your"? Are you not on speaking terms with "yo"?  |
|
|
|
|
|
|
Moving sqldatabase from serverA to serverB