Post reply

How to recreate a database in sql server 2008 express from sql server 7?

  • August 1, 2011 at 8:36 am

    #245280

    I have a sql server 7 database. I want to recreate or duplicate it and work on it in sql server 2008 r2.

    Please tell me how to go about it??

  • August 1, 2011 at 8:46 am

    #1361603

    You can't upgrade straight. You'll need and intermediate step to go to sql 2000 or 2005, then you'll be able to move to 2008 R2.

  • August 1, 2011 at 8:52 am

    #1361610

    Okai. Could you please explain the steps I can follow.

    I have sql server 2008 r2 and management studio already installed on the machine.

  • August 1, 2011 at 8:55 am

    #1361613

    You need an instance of SQL 2000 or SQL2005. Restore the SQL 7 database there, change the compatability level to 80 or 90. Take a backup, restore on the SQL express.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2011 at 8:55 am

    #1361614

    kulkarni.ameya (8/1/2011)

    Okai. Could you please explain the steps I can follow.

    I have sql server 2008 r2 and management studio already installed on the machine.

    Install express 2005. Backup from 7, restore on 2k5. Backup in 2k5 and restore again on 2k8. You'd be done then.

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

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