Things I attempted to date is to visit server explorer:

  • connect with a database
  • choose server title

and attempted to add a database file however it requests an .mdf file and I'm not sure what's this and just how to produce it. My database is really a .sql file

B .sql file, is really a file that consists of claims that may be performed. They are able to contain claims that induce database and tables (along with other stuff) or that manipulate the information within an existing database (like placing records).

If you wish to execute the .sql file, you are able to open it up in Visual Studio after which run it. It'll request you for any link with a Sql Server instance and so the claims is going to be performed.

Here is the MSDN documentation that describes this.