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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-27 : 09:27:57
|
| Cameron writes "We have two exiting SQL 2K servers, one of which we will be only storing reports on. We wish to move the databases over to a new SQL 05 server. What is the best method of moving the data over?" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-02-28 : 13:35:38
|
| simple backup and restore if you want it quickbest is to migrate the databases to 2005, this means looking into your objects and routines and rewriting them to take advantage of 2005--------------------keeping it simple... |
 |
|
|
|
|
|
New SQL Server Replication