locked
Problems while importing a database from SQL Server Express 2005 to SQL Server Express 2008 RRS feed

  • Question

  • Hi All,

    I am a beginner with SQL Server and I am currently upgrading my SQL Server Express 2005 Database to 2008 Express edition. I have installed SQL Server Express 2008 and the SQL Server management studio 2008 Express as well. Now I want to import one of my 2005 databases to 2008. I have an 'Import/Export Data wizard' just under the SQL Server 2008 Folder in All programs and was trying to import my DB through the wizard, It automatically selects the Destination as SQL Server Native SErver 10.0 and the Source file as my Server, still when I click next it says     @ The source database doesnt contain any visible Tables or Views' . The SQL Server NAtive client is also installed on my PC.

    Is there any other method to upgrade my SQL Server Expess 2005 to SQL server Express 2008 ? Or Does anybody know  a solution to the above problem.

    Thanks and regards,

    Sav

     

    Monday, November 28, 2011 4:48 PM

Answers

  • You can detach your DB in SQL Server 2005, copy the files to a different location and then attach this DB from different location to SQL 2008 and from the original location to SQL 2005.

    Note, then you only can attach SQL 2005 to SQL 2008, but not vice versa. In other words, you will not be able to attach DB opened/modified in SQL 2008 to the instance of SQL 2005.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    • Proposed as answer by Maggie Luo Wednesday, November 30, 2011 5:25 AM
    • Marked as answer by Maggie Luo Monday, December 5, 2011 2:44 PM
    Monday, November 28, 2011 4:56 PM
  • In addition to what Naomi has said, you can also use the backup and restore method which just as it sounds you take a backup of the 2005 database and then restore it to the 2008 instance. Note that it has the same constraints that you can only go up in version, not down (2005->2008 not 2008->2005).

    -Sean

    • Proposed as answer by Maggie Luo Wednesday, November 30, 2011 5:25 AM
    • Marked as answer by Maggie Luo Monday, December 5, 2011 2:44 PM
    Monday, November 28, 2011 6:42 PM

All replies

  • You can detach your DB in SQL Server 2005, copy the files to a different location and then attach this DB from different location to SQL 2008 and from the original location to SQL 2005.

    Note, then you only can attach SQL 2005 to SQL 2008, but not vice versa. In other words, you will not be able to attach DB opened/modified in SQL 2008 to the instance of SQL 2005.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    • Proposed as answer by Maggie Luo Wednesday, November 30, 2011 5:25 AM
    • Marked as answer by Maggie Luo Monday, December 5, 2011 2:44 PM
    Monday, November 28, 2011 4:56 PM
  • In addition to what Naomi has said, you can also use the backup and restore method which just as it sounds you take a backup of the 2005 database and then restore it to the 2008 instance. Note that it has the same constraints that you can only go up in version, not down (2005->2008 not 2008->2005).

    -Sean

    • Proposed as answer by Maggie Luo Wednesday, November 30, 2011 5:25 AM
    • Marked as answer by Maggie Luo Monday, December 5, 2011 2:44 PM
    Monday, November 28, 2011 6:42 PM