Import SQL server database using batch

Question

I need to import a database into a SQL Server instance using a batch script and the database is provided by an sql file.

How can I do This?

The SQL file was generated by the SQL Server management studio.

TLiebe · Accepted Answer · 2010-04-19 13:12:05Z

1

SQL Server has a command line utility called SQLCMD. It will let you do things like run scripts or restore a database backup. The -i parameter allows you to specify an input file.

There is also an article here that has a quick intro to SQLCMD.

edited Apr 19, 2010 at 13:12

answered Apr 19, 2010 at 13:04

TLiebe

8,0261 gold badge25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

marionmaiden Over a year ago

Would it be something like this? sqlcmd -U mario -P mario -i file.sql

TLiebe Over a year ago

I believe so but you'll probably also need to specify the server (-S) and maybe a few other things depending on your situation. Type 'sqlcmd /?' on the command line to get a full list of the options. It may take a couple of tries to get it right so try it first on a development server if you can.

Collectives™ on Stack Overflow

Import SQL server database using batch

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related