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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-11-07 : 02:14:36
|
| Dear All,we have a production server with the Ip 172.168.2.231now we have planned to migrate to sql server 2005 from 2000.that is a small database with just 8Gb data, totally 4 databases, and i've around 2 hours of downtime. i've decided to go for side by side upgradation. even then, if i've installed a default instance of 2005, is it possible to connect with the IP? then which server connects? 2000 or 2005?i've planned like this. i'l take all the logins by sp_revlogin, then take the backups of the databases, uninstall 2000, then install 2005 then restore the backups. then run the login script. is this the valid way? or am i missing at some where?please correct me and guide me.my need is the user should connect to the server with IP address as previously.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-11-07 : 02:52:28
|
You can install multiple instances of MS SQL on the same machine and migrate via backup and restore.Yes you can connect with your IP using IP,portnumber e.g. 127.0.0.1,1433Would also advice you not to put your real IP here  |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-10 : 00:39:41
|
| that is not the real IPArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Migration help