Upgrading from SQL 7 to SQL 2008

tachzone12tachzone12 Posts: 3
edited May 28, 2010 12:07PM in SQL Compare Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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 DonahueBrian Donahue Posts: 6,590 New member
    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
Sign In or Register to comment.