• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1188
  • Last Modified:

How to import a .sql file in SQL manager studio

Can anyone tell me what are the step to import a
 import a .sql file in SQL manager studio
1 Solution
Mohammed KhawajaManager - Infrastructure: Information TechnologyCommented:
Open SQL Management Studio, go to File, Open and select the SQL file.  It will open it in a query window.
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
Pratik MakwanaData AnalystCommented:

1.Start SQL Server Management Studio
2.Connect to your database
3.File > Open > File and pick your file
4.Execute it
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now