By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,200 Members | 1,607 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,200 IT Pros & Developers. It's quick & easy.

How to Execute SQL Scripts using Batch file?

P: n/a
Hi,

How can we execute SQL Scripts using Batch file???

i think Batch file should contain Username,Password,Database and
Scripts...
Using that file scripts should run...

How can i give UserName,Password,Database and all those things?

Plz send me details how to do that...if possible with example...
Thanx in advance,
RR...

Oct 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
(ra********@gmail.com) writes:
How can we execute SQL Scripts using Batch file???

i think Batch file should contain Username,Password,Database and
Scripts...
Using that file scripts should run...

How can i give UserName,Password,Database and all those things?

Plz send me details how to do that...if possible with example...
From a .BAT file you can use the command-line tools OSQL or SQLCMD. They
are largely identical, but SQLCMD has some extra bells and whistles. On
the other hand SQLCMD only comes with SQL 2005.

For an overview over command-line options, run OSQL -? or SQLCMD -? at
the command line. For more details, look them up in Books Online.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Oct 10 '07 #2

P: n/a
How can i give UserName,Password,Database and all those things?
>
Plz send me details how to do that...if possible with example...
To expand on Erland's response, you can pass parameters on the command line
and reference using %1 through %9. The examples below execute all the
".sql" scripts in the current folder using the server, database, user and
password passed as command-line arguments.

FOR %%f IN(*.sql) DO SQLCMD -S %1 -d %2 -U %3 -P %4 -I -i "%%f"

FOR %%f IN(*.sql) DO OSQL -S %1 -d %2 -U %3 -P %4 -i "%%f"

--
Hope this helps.

Dan Guzman
SQL Server MVP

<ra********@gmail.comwrote in message
news:11********************@v3g2000hsg.googlegroup s.com...
Hi,

How can we execute SQL Scripts using Batch file???

i think Batch file should contain Username,Password,Database and
Scripts...
Using that file scripts should run...

How can i give UserName,Password,Database and all those things?

Plz send me details how to do that...if possible with example...
Thanx in advance,
RR...

Oct 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.