Hi,
is it possible to backup Sybase making a hot copy of the “database” folder located into Servoy app folder or is it a dangerous procedure?
Update:
I read in Sybase documentation that is possible to perform an online backup using:
BACKUP DATABASE DIRECTORY “path”
I tried with Interactive SQL and it works fine.
Is it possible to trigger this command from within Servoy?
TestDrop.servoy (6.78 KB)
Not directly, it is possible to trigger isql using executeProgram or even better to create a schedule to automatically backup your database. The last example in the documentation shows you how to do that. Doc path:
ASA SQL Reference
SQL Statements
BACKUP statement
jaleman:
Not directly, it is possible to trigger isql using executeProgram or even better to create a schedule to automatically backup your database. The last example in the documentation shows you how to do that. Doc path:ASA SQL Reference
SQL Statements
BACKUP statement
Thanks Jan: I set an event and everything works. I also tried to attach a method to a database trigger and also this option works…
I also tried to attach a method to a database trigger and also this option works…
Can you explain this? or make an: HOW TO?
