Questions tagged [mdf]

Master Database File (.MDF) is the starting point of a SQL Server database. It is the primary data file and also points to the other files in the database.

See the Wikipedia article on Microsoft SQL Server.

Related Tags:

429 questions
4
votes
0 answers

Open an .mdf (Master Databse File) on mac or attach it to MySQL

I have a .mdf file which I've downloaded on my mac and I have no idea what to do with it. I get the impression it was designed for a windows environment and not for a mac or for MySQL. I need a way to either open it so I can see what's inside and…
user1251858
  • 303
  • 2
  • 4
  • 13
4
votes
1 answer

How to open a SQL Server .mdf file with Python (pandas)

I'm trying to open a mdf sql database file that I have saved to my desktop. How do you open it as a pandas dataframe? so far all I have is the following: conn=pyodbc.connect(driver='{SQL Server}', dsn=filepath) Its giving me the error…
Matthew
  • 393
  • 2
  • 4
  • 15
4
votes
2 answers

service based database

I have one problem with service base database, I have used it in one of my application but I dont know if user who'll use it need to have something installed to be able to run application (like you need to have installed NET framework for c#…
Turtloe
  • 41
  • 2
4
votes
3 answers

How to set password or authentication for .mdf(service based database) file in vs2010?

I am developing a stand alone windows application in c# I am using service based database. Can anyone tell me how to protect .mdf database from copying or attaching to sql server management studio without password from Client's machine ?? Is there…
Muhammed Suhail
  • 269
  • 2
  • 6
4
votes
1 answer

Populate checkboxlist with items from database?

Ok, so I want to populate/bind some data to a checkboxlist but cannot seem to binf the right values? I want to populate it with the information from a ROW, not the whole column which is what's happening to me. Here's some code anyways to show you…
crsMC
  • 635
  • 3
  • 11
  • 24
4
votes
1 answer

How can I create .MDF file based on existing Database in SQL Server?

I have a database which is sitting on my local PC. I want to create a .mdf file based on this database. I created an empty .mdf file in Visual Studio. How to connect SQL Server Management Studio and run queries against it? But I want to create .mdf…
Andrey
  • 1,629
  • 13
  • 37
  • 65
4
votes
2 answers

SQL join Query Between Two Different Database File

I am creating a Windows application which have two SQL Server databases. One is in application/startup path and other is in different drive. I have two SQL Server database files with different names. Both are in different location. There are same…
Narendra
  • 43
  • 1
  • 4
4
votes
2 answers

How to protect the sql server 2005 MDF file

How to set the Password for sql server 2005 MDF file. Becoz i want to give the trail package to the client,package including the MDF. After installing the package, the MDF will be placed in C drive, user data will store in MDF file through the…
vijai
4
votes
2 answers

Copying .mdf file from app_data folder to default localhost folder

My friend gave me a database file: record.mdf. I copied that .mdf file to my app_data folder and I can access it. However, the connection string contains absolute path: AttachDbFilename="C:\Users\Dell\Documents\Visual Studio…
coolscitist
  • 3,317
  • 8
  • 42
  • 59
4
votes
2 answers

How to open and edit mdf sql server database files on linux

How to open and edit mdf sql server database files on linux? I use ubuntu!
Tareq Nassry
  • 101
  • 1
  • 1
  • 7
3
votes
3 answers

Setting The Path of an db mdf file in local folder

How come The path I inserted in my Database Context is not working? Here's the code for my path private string dbPath = @"TEST.MDF" DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath); But when I run a query this gives me an…
user962206
  • 15,637
  • 61
  • 177
  • 270
3
votes
1 answer

Is there a SQLite version of the LinqPad nutshell database

I am trying to learn LINQ with LINQPad, but the fact is that I have a notebook. Therefore, I don't want to install SQL Server on it (I am not even conviced that I could do it). Some LINQPAD Examples use a database called nutshell.mdf, I'd like to…
GianT971
  • 4,385
  • 7
  • 34
  • 46
3
votes
1 answer

asp.net mvc unable to connect to SqlServer when creating the users from Register page

I have Visual studio 2008 and Installed MVC2 RTM. For data base I have Sql Server 2008. When I first create a project of type "asp.net mvc web application" I get the default structure of the project and app_data. After I run the project and trying…
Anand Kumar M
  • 728
  • 3
  • 12
  • 25
3
votes
1 answer

SQL Server 2008 Express Edition file size limitation problem

The SQL Server error I encounter as below: Could not allocate space for object 'dbo.xxx'.'PK_xxx' in database 'mainDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding…
foo0110
  • 165
  • 2
  • 3
  • 11
3
votes
1 answer

DataGrip open Microsoft SQL Server Database File

Is there way how to open Microsoft SQL Server Database File (.mdf) in DataGrip?
Petr Kramolis
  • 245
  • 2
  • 12
1 2
3
28 29