Hi, i have a MDF file used by an asp.net application (with sql server 2005 express).

I want to make it to a permanent database in sql server express.

I know that i can attach it from Management Studio, but is there no better way?

Does it exist a way to 'import' or 'migrate' or copy' a .MDF.database into the central sql server, as if created directly in sql server express? After that, i can delete the .MDF file.

Thanks
Hertendreef

I dont think of a better way of doing it. Other way is you can backup and restore it on other servers where you wanted to have the data. In case Attach/Detach, your DB goes offline for a while. But when you have backup/restore done still the DB is online/usable. The MDF restored at the other server can be deleted as you want, since it is a copy of the one running on the other.

Also the import/migrate is not going to be that easy compared to the above said methods.

Hope that helps
Cheers

_________________________
- Vijay G
Strive for Perfection

Thanks