• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

SQL Server 2008 DB convert to 2005 DB

Hello,

I have a database that is compatible with SQL server 2008, how can I restore it over a SQL server 2005 database?
0
Matthew34
Asked:
Matthew34
2 Solutions
 
dsackerContract ERP Admin/ConsultantCommented:
Databases are upward compatible, not downward compatible. You can try the following link, but your chances of success are next to nil, and your effort will be substantial.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx
0
 
COANetworkCommented:
If you have both a 2008 and a 2005 system up at the same time, you can try to DTS data and objects from one DB to another.  It will be longer than a restore, and not every object can be transferred, though.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now