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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2001-07-13 : 10:51:01
|
| Hi Folks,I am trying to upgrade our database server to v7 from sql6.5,then migrate the database, which is at present sitting on the same server with the application sever.Finally create an odbc connection to connect the two servers.My question now, is what is the best way to migrate a database from one server to the other. I intend to use sp_attachdb and sp_detachdb ,then finally restore the database unto the new server from the last backup. But i am sure there is a more straight forward way to do this, any suggestions will be appreciated. |
|
|
|
|
|
database and application upgrade