Solved

How to import a .sql file in SQL manager studio

Posted on 2014-10-07
4
272 Views
Last Modified: 2014-10-09
Can anyone tell me what are the step to import a
 import a .sql file in SQL manager studio
0
Comment
Question by:yguyon28
4 Comments
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 40367264
Open SQL Management Studio, go to File, Open and select the SQL file.  It will open it in a query window.
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40367387
From SSMS 2018 and 2012, File menu, Open menu item, File...
File Open FileThen in the resulting Open File dialog navigate to your .sql file and hit the Open button.
0
 
LVL 2

Expert Comment

by:Pratik Makwana
ID: 40367705
Solution.......

1.Start SQL Server Management Studio
2.Connect to your database
3.File > Open > File and pick your file
4.Execute it
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40367749
Did you try to double-click on file? If you don't have any other database management tool installed the .sql will be set as default file type for SSMS.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question