Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how can i see data in mdf file

i have asp.net application. it has App_Data folder. this folder contain mdf and ldf file. how can i see data within these file. i want to see table structure.

like image 655
Novice Developer Avatar asked Nov 10 '09 21:11

Novice Developer


People also ask

How do I check MDF data?

SysTools MDF File Viewer Software – Screenshots Step 1: Run MDF Viewer and Click on Add file Button. Step 2: Browse the MDF File the system and select the Scan Mode. Step 3: Software Starts the Scanning Process. Step 4: Preview the SQL database objects such as Table, stored procedure, triggers, functions.

How do I unpack an MDF file?

To extract a file or a folder, right-click it and select Extract [file name] from the pop-up menu. You can also drag files from the IsoBuster window and drop them into any folder on your computer to copy them there.

What is inside MDF file?

A file with . mdf extension is a Master Database File used by Microsoft SQL Server to store user data. It is of prime importance as all the data is stored in this file. The MDF file stores users data in relational databases in the form columns, rows, fields, indexes, views, and tables.

How do I view MDF files in Visual Studio?

In Visual Studio, open the project without upgrading it. To run the project, select the F5 key. To edit the database, open the . mdf file in Solution Explorer, and expand the node in Server Explorer to work with your database.


1 Answers

Using SQL Server Management Studio Express you can attach that file.

How to attach a file

However, if you are viewing that in a project in Visual Studio, you can see that in the server explorer.

Also, here is a similar question on the asp.net forums.

like image 160
Anthony Potts Avatar answered Oct 04 '22 04:10

Anthony Potts