How can we help you today? How can we help you today?

Upgrading from SQL 7 to SQL 2008

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
tachzone12
0

Comments

3 comments

Sort by
  • 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.
    Brian Donahue
    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,
    tachzone12
    0
  • 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
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.