Upgrading from SQL 7 to SQL 2008

tachzone12

I have an old machine with SQL 7 on it.
I want to upgrade to adifferent newer server with SQL 2008.

Can I accomplish this using Redgate software? Or do I have to Upgrade the SQL 7 to SQL 2000 first?

I own SQL data compare, but thinking about buying SQL compare also (to migrate the Schema)?

Thanks

Brian Donahue

Hi,

The easiest way that I know of to upgrade a database to a new version of SQL is to back it up and restore it to SQL Server 2008. You will notice that the restore process "upgrades" the database. Just to be sure, you will probably want to also check that the compatibility level property of the database is not "level 70". Compatibility mode makes some aspects of the database behave as if they were still hosted on SQL 7.0.

tachzone12

Brian,

Thanks for the reply..

If I do a backup of SQL 7.0 database, will it restore on a SQL 2008. I have heared somewhere that you have to upgrade SQL 7 to SQL 2000 first, before attempting to go to SQL 2008?

Thanks,

Brian Donahue

Hopefully this should help. It's an MS Technet article about moving databases from SQL 7 to SQL 2008.
http://msdn.microsoft.com/en-us/library/ms177398.aspx