Convert SQL Server Express 2005 .mdf to 2008 .mdf?

Question

Hi I have a Visual Studio solution and an ASP.NET MVC project that uses a SQL Server Express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for SQL Server Express 2008 ?

Thanks

Answer 1

All you have to do is create a backup (.bak) of your 2005 db and then restore it on your 2008 Express server. It's that simple.

If you want to deal with it on the file level, simply detach from 2005 and attach to 2008. If it's solution-created in your AppData all you should have to do is move it to the newer project.