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 |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2007-08-15 : 15:48:43
|
| I've installed a test instance of SQL 2000 on a test box. I want to try the In-Place upgrade to 2005. I installed 2005 on the test box also, but have been unable to see how to perform the upgrade. I thought running 2005 setup again would prompt me for an instance name .... but it just tells me 2005 is already installed. I must be missing something simple. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-15 : 21:55:20
|
backup the database from 2000 and restore into 2005 Server
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-15 : 22:16:44
|
| Sql2k5 installation has upgrade option. |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2007-08-16 : 09:48:01
|
quote:
Originally posted by rmiao
Sql2k5 installation has upgrade option.
I thought so, but I don't see it when I install SQL 2005. Do I install SQL 2005, then run an upgrade, or is there an upgrade option during the initial install of 2005 ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 22:54:10
|
| Does the machine you installed sql2k5 to have previous version of sql? |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2007-08-17 : 08:22:43
|
I figured it out.... (user error) !!  |
|
|
|
|
|
|
SQL 2000 to 2005 In-Place Upgrade - How ?