Importing SQL Server database from a .sql file

I'd like to import a database without knowing its name from a .sql file.

In MySql server it is easy because there is tools like heidSQL in which I can import easily my database from a sql file but in SQL Server I can't find the method to do it.

I tried to read the file in notepad but the encoding makes the content unreadable.

When i execute this query RESTORE HEADERONLY FROM DISK = N'C:\Planning\bdd.sql' i have this

• How can I do it with SQL server?

• Can SQL Server Management Studio do this task or do I have to install a new tool?

Create an empty database or if you have one already target that one.

Open CMD with elevated privilege and run:

sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\path\mysqlfile.sql -o C:\path\results.txt

basically:

• -S: is your servername or localhost

• -d: is the database you are targeting

• -U: is the username

• -P: is the password

• -i: is the path to your .sql file

• -o: is where the logs file will be saved so if you had problem during the importation you can debug them

StackExchange Database Administrators Q#44101, answer score: 9