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

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.

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.

You can issue the Attach command in SQL Management Studio 2008. It will name the database with the path to the . Mdf, but it'll use it no problem.

The database will be in 2005 compatibility mode, but you can certainly change that yourself as you see fit.

Looks like this database is actually 2008 from what that compatibility level says so I think I am ok. I figured out how to attach the file in SQL Server management studio but thanks for mentioning about the compatibility mode. I tried out making a backup and then restoring it using the backup file as a database and it made a new mdf file in the same folder as the original which is what I wanted, wasnt very clear that it was going to do that.Thanks.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.