Subject RE: [firebird-support] Embedded database backup options
Author Alan McDonald
> 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