How to convert a database file (.sql) to a .mdf file?

Question

I have a database that was given to me, but is in a file format (.sql). I want to open it in my SQL Server, but I don't know how, because it says i need a .mdf file?

Can someone help?

Answer 1

A .sql file is (usually) just a series of SQL commands that you execute on the SQL server using your preferred GUI or CLI. Try opening it in Notepad to see what I mean.

Answer 2

Open up the .sql file - if it contains SQL code in plain text, you have most likely received the database as a create script. Run it in SQL Server Management Studio.