how i will convert MS SQL Express Edition to MS SQL 2005

hi friend

now i am using VS 2005 and MS SQL express edition as Database. i want to host the application.

at server it will not support sql express edition. how i will convert.mdf file to MS SQL server 2005

please help me friends.

AOA Manzoor,

There is no special requirement to convert MS SQL Express Database to SQL Server 2005 Database..

You can attach the SQL Express 2005 Database File (.mdf ) with the same database attachment procedure that we follow on SQL Server 2005 Database attachment ,

All you need is

1. Open the SQL Server 2005 Management Studio, Right Click onDatabase Node, ChooseAttach Menu Item

2. Attach Database Form will be open, PressAdd button to add Source .mdf file

3. After pressingAddbutton,Location Database Files Dialog box will be open, select your source.mdf file and pressOK button.

4. PrssOK button , Aftere pressing OK Database Attachment process will be start

Thats All

Thanks

Best Regards,

Muhammad Akhtar Shiekh

|||

Hello,

Can you convert the database around the other way. From MS SQL to SQL Express?

Cheers,

isopro