Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to deploy .mdf file

Tags:

sql-server

mdf

I am trying to make an application, which uses a local .mdf database file (not attached to a sql server). Visual Studio says I have to install SQL Server Express before doing that. I was wondering how I can deploy the application to clients' box. Do they also need SQL Server Express installed?

Thanks a lot

like image 454
Frank Avatar asked Apr 26 '11 18:04

Frank


People also ask

How do I mount an MDF file?

Right-click your MDF file and select “Open with.” Select Daemon tools from the options and the image will mount as a DVD. Windows Explorer will pick it up and you will be able to run or explore the disk just as you would if it were a real DVD.

How do I install LDF and MDF files?

Run SQL Server management studio as an administrator and attach the database. Explicitly grant full control access to the MDF file and LDF file of the database. To do that, Right-click the database files Select the security tab select the appropriate user and grant full control to the user.


1 Answers

They need SQL Server Express installed. Once installed, you need to attach the database file (.mdf) to the server.

like image 130
Nik Avatar answered Oct 14 '22 21:10

Nik