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 - 2002-04-26 : 10:58:00
|
| DELMI writes "Hi,I would like to get some input on the upgrade of our database server from sql 7 to 2000. The important thing is that We are getting a brand new box and upgrading the existing one to this one. My guess is that I should be installing sql 7 on the new machine and restore all the system databases on that then upgrade to sql 2000. Is this a reasonable approach. ?Thank you for your help in advance.-Delmi." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-04-26 : 11:12:26
|
| Sounds fine to me. The SQL7 > 2K upgrade is very straight forward as well.Paul |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-26 : 12:43:45
|
| An easier way would be to install SQL 2K on the new box, then restore your 7.0 DBs onto the 2K box.You can search the forums for "upgrade" and you will see a lot of information on doing this.-Chad |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-26 : 17:34:53
|
| I would (and in fact did) opt for a clean install of SQL 2000 on the new machine like Chad suggests. You can also use detach/attach in place of the backup/restore. When you attach 7.0 databases to the SQL 2000 server it automatically runs an upgrade process on the database itself so that you end up in SQL 2000 mode (dbcompatlevel 80). |
|
|
|
|
|
|
upgrade sql 7 to 2000