Solved

How to import a .sql file in SQL manager studio

Posted on 2014-10-07
4
311 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 49

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL DATEADD 10 81
sql 2016 Integration Service connecting to 2012 3 50
How can I use this function? 3 33
How can I find this data? 3 28
     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 …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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