How do I downgrade a SQL 2008 MDF file for use in SQL 2005?

Question

Someone sent me a MDF file that was created in SQL 2008. I have SQL 2005, and the "Attach" function is rejecting the MDF file.

How can I import this file?

score 6 · Accepted Answer · edited Dec 08 '11 at 20:22

6

You can't. You need to attach to a SQL 2008 instance and synch/BCP/SSIS the schema and contents.

Blogged yesterday by Paul Randal referring to SQL Server 2008/SQL Server 2008 R2 differences

edited Dec 08 '11 at 20:22

Mark S. Rasmussen

answered Aug 26 '09 at 08:25

gbn

1

ugh. Not the answer I wanted, but accurate enough for answer credit... ;) – Shaul Behr Aug 26 '09 at 08:29

1 Answers1