dfincham28
asked on
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER