Subject Re: [firebird-support] Re: running firebird without installing it
Author jesus martinez
Adam, i really appreciate your answers and the
rest of the members of the list.

i also think that i was not very clear about
my issue.

i have to develop a software that another
person will sell to his clients.

me <--> my client <--> his clients

netheir my client nor his clients understands
anything about computers. i will not be "technical
support" of anybody.

the problem comes when:
1) because of economic situation, win98/me is
a common computers in my country, to both
servera (p2p lan) and clients. they are people
that have win-domains, but they are only few.

thats why i am concerned and looking for a
rdbms that works on a machine designed to be
the server.

2) the system will only make queries to the database,
not updates or inserts.
because of this, the first and simple approach
is to share a folder (even in a designed server or
in a domain), public an ms-access file on it,
and just it. (to say more, not many concurrency
will usually happend, but i must be prepared to
deal with it when it appears)

the problem comes when i also have to develop
a "daemon" (service or application, depending on
the win-xx tech available) that must connect
to internet and look for updates.

updates will be sql_scripts with updates, inserts,
and deletes...

because of this, i choosed to enable a rdbms
that will centralize the records.

as you can see, i am not worry about security
or db's corruption right now. i just need to
access to the same db via different clients.

3) a firebird server can already be installed on the
server. i wish to firebird let me install to
different instances of it, the already installed
and mine.

i mean, because i wont have access to the
machines where the system will be installed
(the instalation will be done by my client to
his clients) i prefer to individualize my system
(clients-apps and server-app) with the rest of
the server´s programs.

because i am developing the solution in delphi,
i also research on flashfiler, to create my
own server(rdbms)-application (by this way i
can warranty to my self that no other instalation
of my own server will be installed in the server)
but i finally select firebird.

i think it is clear why i cant use embedded
version: i need to install firebird on the server
(or update it if it is already installed)
create my alias and restore my "empty" db
of 40.000 records (that is compressed inside my
installer.exe) into it.

if the way to do that is unpacking the backup
file (from installer.exe) and then execute gbak,
ok, i will hear your recommendation.

my questions about that was the following:

- i will use gbak not to avoid corrumption of
possible opened files, but to restore the
already-done file.bak

so, will the gbak restore the users of the
tables, the grants, the roles, and all the
things ? or i also must execute some
queries ?

- what other things must i be concerned about ?

thanks one more time,
jesus






__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas