Have SQl 7.0 database need upgrade to 2008

Question

Have SQl 7.0 database need upgrade to 2008

fizzleme

SSCertifiable

Points: 6906
More actions
October 20, 2010 at 11:57 am

#230107

We have an ancient database that needs upgrading. Any advice? What is the best approach?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Meet George Jetson SSChampion Points: 11627 More actions · Answer 1

Unfortunately you cannot do a direct upgrade from SQL 7 to SQL 2008, please review the following article for acceptable upgrade versions.

http://msdn.microsoft.com/en-us/library/ms143393.aspx

One option would be to do a side by side, where you script all tables, schemas, yada, yada............

A second option would be to get your hands on a free trial version of SQL 2000 or 2005. These are only good for 30, 60, 90 days, but should allow you to get the job done.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

WayneS SSC Guru Points: 95460 More actions · Answer 2

chris.s.powell (10/20/2010)
Unfortunately you cannot do a direct upgrade from SQL 7 to SQL 2008, please review the following article for acceptable upgrade versions.
http://msdn.microsoft.com/en-us/library/ms143393.aspx
One option would be to do a side by side, where you script all tables, schemas, yada, yada............
A second option would be to get your hands on a free trial version of SQL 2000 or 2005. These are only good for 30, 60, 90 days, but should allow you to get the job done.

SQL 2005 is the last version that can directly upgrade a SQL 7 database.

The earliest database that SQL 2008 can directly upgrade is SQL 2000.

So, in order to upgrade it to 2008, you will need to first upgrade it to either SQL 2000 or SQL 2005.

I know that on our purchase of SQL 2008, it allows a download of SQL 2005.

I'm not 100% sure about this part, but doesn't the free trial version limit the size of the database? If so, this may be an issue.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

fizzleme SSCertifiable Points: 6906 More actions · Answer 3

Good advice. I am wondering if free trail versions are still available for sql2000 or 2005?

I may have a developer edition of one of them...somewhere.

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.

Meet George Jetson SSChampion Points: 11627 More actions · Answer 4

Developer edition is even better. If you can find that copy - perfect.

Good luck with the upgrade.

C

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

fizzleme SSCertifiable Points: 6906 More actions · Answer 5

Thanks. Happy trails to you.

When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

Once you've accepted your flaws, no one can use them against you.