Link to home
Create AccountLog in
Avatar of Andrew
AndrewFlag for United States of America

asked on

How to import a .sql file into SQL Server 2008

What is the best way import a .sql file into SQL Server 2008?

File attached...

TIA,
Andrew DanforthFacultyApplicantsScript.sql
Avatar of laneduncan
laneduncan
Flag of United States of America image

You can use sqlcmd if your goal is to script it:  http://msdn.microsoft.com/en-us/library/ms162773.aspx

But it's probably easiest for a one-time execution just to paste it in to the SSMS query window.
SOLUTION
Avatar of laneduncan
laneduncan
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If you need some assistance with SSMS, I can upload some screen shots.
ASKER CERTIFIED SOLUTION
Avatar of Lee
Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account