How to move a sql server express mdf file to a different sql sever express server?

Question

I'm trying to move my database.mdf file from a development environment to a SQL Server Express server that is hosted on my VPS - but I can't figure out how to attach the file to my database server. Help!

Answer 1

sp_attach_db (or CREATE DATABASE FOR ATTACH) - don't forget to bring the LDF (log) files, too.

Answer 2

I am not sure if you can, but you could use the Sql Studio Management Express, which allows you to connect (and then attach) the database.

Your application could also be using a local instance and directly connect to the database.mdf in the app.data folder.

Answer 3

Dear,

This will help you

http://support.microsoft.com/kb/224071