upgrade sql7 to sql2005 - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

upgrade sql7 to sql2005

Author

Topic

bassem_farouk
Starting Member

18 Posts

Posted - 2010-05-27 : 00:49:26

what is the correct way to do it?

Thanks

bassem_farouk
Starting Member

18 Posts

Posted - 2010-05-27 : 00:59:55

i think the best way is to install sql2005 then backup the sql 7 and restore it in 2005?

Thanks

Kristen
Test

22859 Posts

Posted - 2010-05-27 : 04:43:01

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Refers to SQL 2008, but pretty much all of it relevant to SQL 2005

Why not upgrade to SQL 2008? You will buy yourself more time before you have to upgrade again ... and do all the same testing works yet again ...

(Although you cannot restore SQL 7 onto SQL 2008, so you would have to go via either SQL 2000 or SQL 2005, as discussed in that link)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-05-27 : 05:07:05

"(Although you cannot restore SQL 7 onto SQL 2008, so you would have to go via either SQL 2000 or SQL 2005, as discussed in that link)"
Hmmmm, so you need to buy a SQL 2000 or 2005, restore to the 2000/2005 and then backup again and restore it on 2008.

KH
[spoiler]Time is always against us[/spoiler]

Kristen
Test

22859 Posts

Posted - 2010-05-27 : 05:33:16

Something like that ... although Express will do if database doesn't exceed Max Size limitation

... anyone still supporting 6.5? 6? (that would have to upgrade to SQL 2000 - which is presumably no longer sold?