I'd like to import a database without knowing its name from a
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?