how to convert mdf file version 655 to 612 in sql sever

mdf file version 655 to 612
meroscorpAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
Well, you can't really. 655 is SQL Server 2008 and 612 is SQL Server 2005.

There are a few "gotchas" in VS2008. Not least of which is an assumption of SQL 2008.

Could also be your hosting site is not supporting SQL 2008.

Now... Before Anything else, back up your ASPNETDB.MDF data before doing any of the suggestions just in case.

The ASPNETDB.MDF and aspnetdb_log.ldf files get recreated the next time you run your application. So, you can try removing them from your App_Data folder (stop SQL server first).

Also, there are a few suggestions on : http://forums.asp.net/t/1432690.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim P.Commented:
Once a sql mdf/ldf is taken to the next level you can't go back. The only way is an Import/Export to a SQL 2005 db. You might be able to use the db publishing wizard.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Applications

From novice to tech pro — start learning today.