How to extract the database file when using SQLExpress in Visual Studio

I have made my database in SQLExpress and its a master database . I would like to create a CD for my project so need the database file. I am not able to find th开发者_运维技巧at file please suggest a solution thanks!

Your database files would be in the App_Data folder by default if you are using SQL-Express provided with Visual Studio.

You can generate an SQL script of your database which can be used to re-create it in different db server by running the script again. For this right-click on the database in the Server Explorer and select Publish to Provider.

You'll need the .mdf and .ldf in the SQL Server installation directory, but if you've created everything in the master database, I'd recommend creating a different database and moving everything there instead. The master db shouldn't be used for stuff like that.