Subject Re: Using the Embedded Server
Author Adam
--- In firebird-support@yahoogroups.com, "csiagent029"
<csiagent029@y...> wrote:
> Thanks for your reply.
>
> And you got me thinking about stuff I hadn't considered really.
> The thing would be, how do you run a script to initialize the database
> at setup?

To be honest the easiest / fastest way is to distribute the actual fdb
file (since you are talking about embedded you are only talking about
win32 so endian is not an issue). While you could write a script to
create the database, connect to it and fill it with data, save the
user 5 minutes by doing it for them. If file size is an issue (eg
internet distribution), you could use gbak and your installer would
compress the fbk file quite well. Of course you would then need to
include gbak, so it really depends on how much data you have in your
"empty database" which way you go there.

Or on an existing firebird database for that matter?
> Do you use a particular installer for that?

I use nullsoft NSIS (the guys that wrote winamp before AOL broke it)
and it serves me well. Partly because I am cheap ;), partly because it
can use LZMA compression which means my installer which includes
Firebird (superserver), the database and the application is still
smaller (by a few MB) than the zip file of the application alone. The
new GUI also looks much nicer, more like msi.

> Thanks for any insight you can give me on this. It's the first time
> I'm trying to deploy an app that should install everything on its own.
> Before I've installed the apps myself for the most part.
>

If you are using embedded, you do not have to worry about breaking
some other apps Firebird installation.

Hope that helps
Adam