CODEWITHSUNDEEP
sqlsql-server-2005
Brij
Brij

Reputation: 21

How can i add mdf database to Ms sql server database

I have given asp.net membership provider security into my web application for login and created database into the ms sql server all working fine on local server but, when I transfer my database local machine to server login credential is not working. I am guessing its happen because, I have used asp.net membership security and it has created .mdf file in my app code file, can any help me please now how can, I add this .mdf database into my Ms sql database...?????

Upvotes: 0

Views: 630

Answers (2)

Damir Sudarevic
Damir Sudarevic

Reputation: 22187

The simplest way is to detach/attach a database. You may need both, mdf and ldf files. You should also transfer logins between servers. See how-to here.

Upvotes: 0

Burt
Burt

Reputation: 7758

Google for Attach Database. An mdf is a detached database image and can be copied, reattached ...

Upvotes: 1

Related Questions