![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Mon, May 6 2013 12:19 PM | Permanent Link |
Owen | I want to incorporate functionality that will perform a schedule event (backup). The manual says; Scheduled Events - DBISAM allows the definition of scheduled events for a database server. Scheduled events are stored in
the configuration file for the server. A post on the forum says; The scheduled events are simply something, like several other things in DBISAM, that need to be coded directly into the server. It's why we ship the source code to the dbsrvr.dpr project. My question is, where is the configuration file? And is there documentation anywhere that describes how to do this? |
Mon, May 6 2013 1:39 PM | Permanent Link |
Raul ![]() | This refers to the server configuration file that you should not edit
directly. Use the server admin tool to access the server and create the event definition with appropriate schedule. Then you still need to actually implement what happens when the event takes place - in the OnServerScheduledEvent. The manual does actually describe a backup sceanrio so just follow it under Scheduled Events: http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=XE3&topic=Customizing_Engine Raul On 5/6/2013 12:19 PM, Owen wrote: > I want to incorporate functionality that will perform a schedule event (backup). The manual says; Scheduled Events - DBISAM allows the definition of scheduled events for a database server. Scheduled events are stored in > the configuration file for the server. > > A post on the forum says; The scheduled events are simply something, like several other things in DBISAM, that need to be coded directly into the server. It's why we ship the source code to the dbsrvr.dpr project. > > My question is, where is the configuration file? And is there documentation anywhere that describes how to do this? > |
Tue, May 7 2013 4:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Owen,
<< My question is, where is the configuration file? And is there documentation anywhere that describes how to do this? >> The configuration file is the dbsrvr.scf file that is stored in the same directory as the dbsrvr.exe file. It contains all of the database, user, server-side procedure, and scheduled event definitions for the server. You can modify it interactively by using the Server Administration Utility that comes with this DBISAM download: http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamadd&majorversion=4&version=4.35 And you can modify it programmatically using the information provided here: http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Server_Administration If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
Wed, May 8 2013 4:43 PM | Permanent Link |
Owen | With regard to the server utility. I see status, server, users, databases, database users. There is nothing listed in our database under procedures, procedure users and events. I see how to add a procedure or event, but that seems like name only.
In other databases I am familiar with one would write some sql that contains a create procedure you could store a procedure in the database and then schedule or run it. Or you might type it into GUI DBMS tool. How do you add the guts of the procedure or event in DBISAM. I think I am missing something. |
Wed, May 8 2013 5:22 PM | Permanent Link |
Raul ![]() | On 5/8/2013 4:43 PM, Owen wrote: > I see how to add a procedure or event, but that seems like name only. Correct - you add a name and create the schedule for the event. And then you need to actually write source code to implement the event and recompile a custom version of the server. That's what manual means when it says: "The scheduled events are simply something, like several other things in DBISAM, that need to be coded directly into the server". > In other databases I am familiar with one would write some sql that contains a create procedure you could store a procedure in the database and then schedule or run it. Or you might type it into GUI DBMS tool. DBISAM is an mainly an embeddable database engine targeted towards developers who would implement like backup themselves in their application and surface an end-user interface for it. There is end-user ability to do what you want. The dbsys utility allows you to do on-demand backups manually. Also you can implement the backup quite easily using just windows file copy as long as you can shut down the server for brief amount of time: - stop the dbisam server - backup the databases (folders) by just making a copy of them (or zippnig them up or using a file-system backup utility) - restart the server. All of the above can be easily done using a windows batch file and widows built-in scheduling. > How do you add the guts of the procedure or event in DBISAM. The manual does actually describe the backup scenario so just follow it under Scheduled Events (again assumption here is that you have access to delphi compiler and can recompile the dbsrvr): http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=XE3&topic=Customizing_Engine Raul |
Thu, May 9 2013 10:54 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Owen,
<< In other databases I am familiar with one would write some sql that contains a create procedure you could store a procedure in the database and then schedule or run it. Or you might type it into GUI DBMS tool. >> Our newer product, ElevateDB, works that way. DBISAM is more geared towards highly-distributed, embedded databases in Delphi applications, and not as much general, interactive usage, when it comes to coding certain aspects of the database such as scheduled events, server-side procedures, and triggers. Tim Young Elevate Software www.elevatesoft.com |
Wed, May 15 2013 12:30 PM | Permanent Link |
Owen | Thanks Raul and Tim. That information was helpful.
|
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |