Downgrading a SQL 2008 db to SQL 2005

Is it possible to downgrade a SQL 2008 database so that is can be restored in 2005?
dfincham28Asked:
Who is Participating?
 
chapmandewCommented:
Yeah, you'll likely need to import the data you need from the 2008 db into the 2005 db.  you may have to install a CTP of 2008, restore the db there and then import the data into your 2005 db from there.

0
 
chapmandewCommented:
Unfortunately, probably not...why?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree: you cannot do that.
you would need to "migrate" the database objects...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
dfincham28Author Commented:
A client has updgraded a db to 2008 added some vital data to it and now I need to analyse it against the orignal version which is in 2005. We are currently still standarised on 2005. Therefore I would like to ask the client to backup there version and downgrade it so that I can analyse it.
0
 
Mark WillsTopic AdvisorCommented:
Once in 2008, you are stuck. I do recall a mr. chapmandew describing a script facility where you could export both data and structures - but the client would have to do that.

And chapmandew also raises an interesting thought. Install Sql Server Express 2008 with tools (it is free), and look at  / do the scripting / export wizard thingy yourself (and save a bit of face with the customer at the same time).
0
 
abhijit_kCommented:
Generate SQL Database Script and IMport the data from the 2008 Database to 2005.
0
 
jjj123bCommented:
You can use the Export tool in 2008 to export the database into a new 2005 database.

Right Click on DB in the database node.
Select Export from the pop-up menu.
Walk through the dialogs.

As destination choose an existing 2005 server, create a new DB on it if needed.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.