Dump/Load db as background process at runtime?

[LucieLastic]

hi All

Is it possible to call the equivalent of a 'Dump database' and 'Load database' at runtime from an application. I've done this already with an Oracle db by starting a background process using the command Exp.exe at a command prompt. Can it be done for a Sybase db?

many thanks for help
lou

 

[LucieLastic]

It's ok, I've got it working.

 

[JeanNiBee]

Hi

Please feel free to share with us. We may not have been able to help you but we are more than willing to learn from your solutions.

Thanks.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[LucieLastic]

hi JeanNiBee

I'm more than happy to tell you but it's really only code related and not different from doing it in isql.

I'm using Delphi 5 (a pascal development tool in case you're not familiar with it) and using one of it's DB components (a TQuery), just passed the Dump Database command straight to it and it processed it no problem. I was expecting it to fail as I was unable to call a Truncate Table command from it before. Only problem now, it returns straight away and I don't know when it's finished / - I will have to check myself.

lou