Restore SQL 7 DB to SQL 8 - Possible?

[gavm99]

Hi all,

I have a failed NT Server running SQL 7.

I am thinking I will restore the SQL DB to a Win 2k3 Server running SQL 8 - can this be done?

Do I need to convert it in anyway first?

Thanks.

 

[Catadmin]

It can be done and it should do some bit of automatic "upgrading" as you restore it to SQL 8 (SQL 2000). However, as there are T-SQL changes and datatype changes between 7 & 8, you might find some problems with procs, views, functions, and jobs if you don't go over them with a fine tooth comb to make sure you've updated everything post upgrade.

I've never upgraded from 7 to 2000, so I'm not sure if there's an upgrade advisor available between the two. But I know you can upgrade SQL 7 to SQL 2005 (also known as SQL 9) and that advisor can be found at:

http://www.microsoft.com/downloads/...6B-7E05-4322-A677-95AB44F12D75&displaylang=en

I advise going straight to 2k5 if you can get a copy. After all, why stay a version behind if you have to upgrade anyway? And SQL 2k5 is SOOO COOL! @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[gavm99]

Hi there,

All worked fine!!!!! No issues at all, I feel lucky today, time for a lotto ticket!!

Thanks.