Hello,
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.
+1
A:
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.
TLiebe
2010-04-19 13:04:43
Would it be something like this? sqlcmd -U mario -P mario -i file.sql
marionmaiden
2010-04-19 13:19:30
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.
TLiebe
2010-04-19 13:26:18