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?

Improve company productivity with a Business Account.Sign Up

x
 
chapmandewConnect With a Mentor Commented:
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
 
chapmandewConnect With a Mentor Commented:
Unfortunately, probably not...why?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I agree: you cannot do that.
you would need to "migrate" the database objects...
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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 WillsConnect With a Mentor Topic 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_kConnect With a Mentor Commented:
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.