Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

jj

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

  1. How can I do it with SQL server?
  2. Can SQL Server Management Studio do this task or do I have to install a new tool?
share|improve this question

migrated from stackoverflow.com Jun 8 '13 at 7:26

This question came from our site for professional and enthusiast programmers.

1  
How did you get this file? .sql are script files that should contain readable code which you can open and run from Management Studio. This does not look much usable. –  Nenad Zivkovic Jun 7 '13 at 10:51
4  
SQL Server backup files are usually named .bak and you can restore them with SSMS. However it is possible to name the file otherwise. Perhaps you can try restoring it and see if it's valid backup. Right click on Databases node in SSMS and choose Restore Database... –  Nenad Zivkovic Jun 7 '13 at 10:54
1  
Rename .sql file to .bak and try it again. –  Devart Jun 7 '13 at 11:04
2  
try running this Query: RESTORE HEADERONLY FROM DISK = N'C:\FileName.sql' replace correct path. –  Vishal Gajjar Jun 7 '13 at 11:07
1  
Yes, run the query proposed by @VishalGajjar. If it is a valid backup file you will receive info about what it contains. If not you'll get a red message saying it is incorrectly formed. –  Nenad Zivkovic Jun 7 '13 at 11:22
show 3 more comments

1 Answer

Yes, you can do it with SQL Server Management Studio Here is the instructions how to ! http://technet.microsoft.com/library/Cc966390

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.