How to convert .sql file into .mdf file?

Question

I have a .sql file. How can I convert this .sql file to a .mdf SQL Server database file?

I know that .sql file is nothing but a script file if I open the .sql file in notepad it will show me the db code I can simply copy those code and paste into SQL Server Management Studio.

Is there any other way to convert .sql to .mdf file?

Does youe SQL file have `CREATE DATABASE` in it? What happens when you run it? — Nick.Mc, Aug 10 '14 at 11:51
Yes in the .sql file their is a CREATE DATABASE query in it. — Subho, Jul 23 '15 at 06:23

score 4 · Accepted Answer · edited May 23 '17 at 11:59

4

Unless your SQL file contains the script to create a database, your question wouldn't make any sense. If it does contain such script you need an environment to execute it. There are many tools that will allow you to do that. For example, many IDE tools that integrate with SQL Server have such capability.

So to answer your question: it is impossible to convert SQL file to MDF. You, however, can sometimes use an SQL file to build MDF.

edited May 23 '17 at 11:59

Community

1
1

answered Aug 10 '14 at 00:15

PM 77-1

12,933
21
68
111

Thanks for solving my problem. :) – Subho Jul 07 '15 at 05:49

How to convert .sql file into .mdf file?

1 Answers1