All geek questions in one place

Best way to view mdf file from local computer?

I am working on an ASP.NET MVC site that will have a database. While I am at this very early stage of testing / concept, I do not place the database anywhere, only inside the local mdf file. What are some tools that I can use to connect to a local test server so that I can view tables and run test queries against the information in them without having to run my own code representations? I'm interested in something like Sequel Pro for Mac or phpmyadmin for Linux (the OS doesn't matter much since I'm working on a Mac developing inside a win 7 virtual machine).

Thank!

(NOTE: I understand that it is possible to get table information that is dumped using Visual Studio, but it seems slow and not too useful ... if I don't have a good way to use VS2010, how would I use one of the tools mentioned above?)

+3
source share
2 answers

You can use SQL Server Management Studio Express to view it, as well as do several other useful things, including table design, etc.

+4
source

Consider using the built-in tools directly in Visual Studio. You will need SQL Express, but you will not necessarily need Management Studio.

Visual Studio ( ) , .

  • .
  • Microsoft SQL Server
  • .mdf
  • , , ..
+1

Source: https://habr.com/ru/post/1758817/

More articles:


All Articles