How to Execute SQL Scripts using Batch file?

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...

Re: How to Execute SQL Scripts using Batch file?

(raghutumma@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: How to Execute SQL Scripts using Batch file?

> 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

wrote in message
news:1192032042.088785.7800@v3g2000hsg.googlegroups.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...
>
>