Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 16 of 16 total
Thread Backup of CS Data
Mon, Jan 14 2008 2:21 PMPermanent Link

Gordon Turner
Tim Young [Elevate Software] wrote:
>
> Yep, that's all you need to do.   Well done. Smiley

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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image