On Friday, January 14, 2005, at 09:14AM, Alan McDonald <alan@...> wrote:

>
>> Hi Alan,
>>
>> Once again, thanks for taking the time to reply.
>>
>> On Thursday, January 13, 2005, at 10:59PM, Alan McDonald
>> <alan@...> wrote:
>>
>> >
>> >> Hi all,
>> >>
>> >> I have an application which used an embedded FB database. I was
>> >> wondering what my best options were to back up the database while
>> >> the application was running?
>> >>
>> >> Do I need to use gbak and call it from the command line?
>> >>
>> >> Or is a component a better option?
>> >
>> >use the IBOAdmin components - you can backup using the services API
>>
>> As per my question regarding transactions, I apologize for not
>> being clear on which components I am using. IBOAdmin are
>> third-party components, whereas I am using the Interbase
>> components which come with Delphi 7.
>>
>> >
>> >>
>> >> Can I just disconnect my application from the database and just
>> >> copy the database file and then reconnect to the database once done?
>> >
>> >you could but don't. Use the backup method it's always safer.
>> >
>> >>
>> >> I believe that (I could be wrong) I need to disconnect from the
>> >> database when using FB as an embedded database, is that correct?
>> >>
>> >
>> >no you stay connected - you can create as many connections to
>> the database
>> >as you like from the single loaded embedded server.
>> >Alan
>>
>> Thanks for the tips.
>>
>> Cheers,
>> Diego
>
>please be aware that IBX components are not a good long term choice for use
>with Firebird. The will not be addressing any issues which arise out of
>incompatibility with Firebird.
>That said, IBX have admin components which allow you to backup with the
>embedded server using the Services API. You don't use gbak and you don't
>need a separate process and you don't need to disconnect from the database.
>
>You had best scout around for other component sets before you get too hooked
>on IBX.
>Some suggestions, UIB, IBO, there's also an express driver from upscene.
>Alan
>

Alan,

Interesting comments, re: IBX. I have not released version 1.0 of the application. I guess if I was to look at other components then what the amount of work involved in switching to other Firebird database components is. Thanks for the tip.

Cheers,
Diego