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 |
|
masterlear
Starting Member
2 Posts |
 Posted - 2008-03-20 : 11:47:31
|
| We have a SQL server 2000 which is experiencing hardware failure and parts can no longer be found. So we bought a new server with SQL server 2005. We need to move all of the databases from the 2000 server to the 2005 server, then somehow get all of our web applications to point to the 2005 server. The problem is that the web applications are connecting to the the SQL server by name, and the code for the web applications have been lost years ago, so recompiling is not an option. I hear it is possible to "alias" the new server. I'm not sure what that means or how to do any of database moving as I am a graphic artist by trade and have been tasked to save the company data. Any help on this would be much appreciated. Thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-20 : 12:12:35
|
| I would recommend you : 1)run the Upgrade Wizard which will give recommendations for changes that need to happen prior to moving to sql 2005 .2)Create a testplan/ test run on a test server sql 2005.Test applications3)Create a rollback plan4)Implement on live5)Hire a sql server dba for a couple of days. Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Old Server to New Server