.bat file to export sql 7.0 database

[DavidatWork]

Hi,
Does anyone know where to get info on how to write a .bat file that will stop a sql 7.0 database / export the data to a file then restart the database? Im trying to do this so I can get a complete database file for our backup process.

Thanks for any help you might have.

regards,
DavidatWork

[sijpie]

Oh, this is going back a few years, but it is exactly what I used to do.

You can't access the database directly from DOS, but the way it works is that the batch file calls the command line SQL programme and then tell it to take its input from a file rather then from the keyboard.

So first you need to record exactly the keystrokes that you use if you were to do it manually, including the logging in, and quiting, etc, etc. (remember that once running it will not take any keyboard input!!)

This you enter into a text file, save it as say backup.inp

if we assume that the SQL command-line programme is sqlbase.exe, then you write your batch file, which is pretty simple:

sqlbase.exe < backup.inp

That's it!
This calls sqlbase.exe and tells it to read input from backup.inp

I would suggest to start off with an easy input file, just logging in, and quitting. Then build it up.