SQL help!

[pctweak]

How do i get the following to work in a .bat file. I have to manually type this in each time and it sucks. When I put it in a .bat or .cmd file it will not work..
Thanks Adam


Osql –Usa –Pais
pause
drop database aisdb

go
restore database aisdb from disk='C:\aisbackup\ais_backup.dat' with
move 'AIS' to 'C:\program files\ais\rxsign\aisdb.mdf',
move 'AIS_log' to 'C:\program files\ais\rxsign\aisdb_log.ldf'
go
Pause

 

[LordOfLA]

can you not give Osql a command file to read from disk?

 

[fitz]

usage: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary]

Looks like you can use the osql -i to use an input file.

 

[X-Istence]

What SQL server is OSQL?

 

[NetRyder]

What SQL server is OSQL?

Looks like a command-line tool for MS SQL Server.

 

[X-Istence]

Leave it up to Microsoft to confuse people . All others have their tool named after the SQL product.

mysql
psql
fbrd (FireBird, dun know if they still do)
sqlite

osql does not fit in with any database engine I know

 

[fitz]

Leave it up to Microsoft to confuse people . All others have their tool named after the SQL product.

mysql
psql
fbrd (FireBird, dun know if they still do)
sqlite

osql does not fit in with any database engine I know

sure.. that's why oracle's command line tool is called sqlplus..

 

[X-Istence]

sure.. that's why oracle's command line tool is called sqlplus..

Hrm, I did indeed forget about Oracle, however on the machines I have worked on with Oracle the command line was always called orasql.

 

[pctweak]

I did get this to work. Made a cmd file that called a .sql file and that worked great