Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 16 of 16 total |
Backup of CS Data |
Mon, Jan 14 2008 2:21 PM | Permanent Link |
Gordon Turner | Tim Young [Elevate Software] wrote:
> > Yep, that's all you need to do. Well done. Does it matter which version of Delphi I use to re-compile the Server (Delphi 5, Delphi 7, Delphi 2006)? -- Gordon Turner Mycroft Computing http://www.mycroftcomputing.com |
Tue, Jan 15 2008 3:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Gordon,
<< Does it matter which version of Delphi I use to re-compile the Server (Delphi 5, Delphi 7, Delphi 2006)? >> No, they should all work. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Aug 12 2008 6:32 AM | Permanent Link |
Paul Endersby | Sorry to resurrect an old thread, but my customer has a requirement to have the backup file at a client that has been performed at a remote site
(drive mapping and HDD access is not an option). This rather throw away statement made by Jason Lee made me think that this was any easy DBISAM mechansim that I was missing. Is there a DBISAM mechanism for strwaming files Server -> Client that I could use, or is a special coded FTP transfer of some description my only option? Cheers, Paul DBISAM 4.25 Jason Lee <computerguy@wavecable.com> wrote: Gordon, Depending upon how large your database is you can create the backup and then stream it to your workstation using a server procedure. ~Jason Lee Gordon Turner wrote: > Looking at the Procedures and Events option in the Server Admin > module... Am I correct in assuming that you need the Server Source to > add to these? If not, where do I go about adding the code for a backup > procedure? > |
Tue, Aug 12 2008 11:03 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< Sorry to resurrect an old thread, but my customer has a requirement to have the backup file at a client that has been performed at a remote site (drive mapping and HDD access is not an option). This rather throw away statement made by Jason Lee made me think that this was any easy DBISAM mechansim that I was missing. Is there a DBISAM mechanism for strwaming files Server -> Client that I could use, or is a special coded FTP transfer of some description my only option? >> As he indicated, you'll have to write a server-side procedure to do so. Basically, the backup file is loaded as a result parameter to the server-side procedure, and then can be saved to a local file on the client side. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Aug 14 2008 10:22 AM | Permanent Link |
Paul Endersby | I've now written my server side procedure that backs up the database and then reads in the backup file into a string (via a TFileStream). This
string is then passed as the result of the server side proc. <pseudo> backup_db_filename := backupdatabase; ServerSession.RemoteParams.ParamValues['result'] := LoadFile(backup_db_filename ); //LoadFile reads the backup file using a TFileStream and writes it to a string </pseudo> Not too sure if that's what you intended when you wrote my reply, but it seems to work. Only thing I find now is that all my other server side procs seem to take ages to respond. I've put a breakpoint on the DBISAMEngine.OnServerProcedure and a breakpoint in my client code when the procedure is called and the proc execution request seems to dissapear off into the ether somewhere for a few seconds. Is there a buffer or something I need to clear or purge after using a proc return parameter for a very large string? Cheers, Paul. |
Thu, Aug 14 2008 10:54 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< I've now written my server side procedure that backs up the database and then reads in the backup file into a string (via a TFileStream). This string is then passed as the result of the server side proc. <pseudo> backup_db_filename := backupdatabase; ServerSession.RemoteParams.ParamValues['result'] := LoadFile(backup_db_filename ); //LoadFile reads the backup file using a TFileStream and writes it to a string </pseudo> Not too sure if that's what you intended when you wrote my reply, but it seems to work. Only thing I find now is that all my other server side procs seem to take ages to respond. I've put a breakpoint on the DBISAMEngine.OnServerProcedure and a breakpoint in my client code when the procedure is called and the proc execution request seems to dissapear off into the ether somewhere for a few seconds. Is there a buffer or something I need to clear or purge after using a proc return parameter for a very large string? >> Are you calling the RemoteParams.Clear method before setting the result ? Apart from that, everything is freed or resized back to the normal size automatically by DBISAM (send/receive buffers and remote params before/after the server procedure call). -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 06:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |