Subject | Re: [ib-support] Cross-db query |
---|---|
Author | Antonio Parrotta |
Post date | 2002-10-28T11:53:30Z |
Helen,
I try to clairly explain you what I would like to have:
the problem is that I need for this strange arrangement since I have some tables that are "common table" and some other that depends of kind of "service" that has to be managed. So I have only one "master" db, and many "Service" db, I don't know how many "Service" db I can have, but each "Service" db will have all the master tables plus other tables. Again, all the Sevice tables that refer to master, must contains the same data for all the Service dbs. I have already created and tested an Delphi application that works on a Access database. Using the linked table, I'm able to obtain what I want, but since my database going to be "too big", you know that access will become unuseful (performance very slow). So I'd like to migrate to Firebird, but before that, I need to know if it meet to my aim. So, it's possible to simulate the "access linked manager" with interbase or firebird?
Many thanks
Antonio
ps: IBReplicator (or other similar tools ) I think can solve my broblem, but I'd like to solve this problem via "query" if possible
Helen Borrie <helebor@...> wrote:
I'm just extremely curious as to *why* you want to have such a
disintegrated and contradictory arrangement...and, moreover, why you think
that a RDBMS which is designed to *protect* integrity would be useful to
your design.
heLen
---------------------------------
MIo Yahoo! : personalizza Yahoo! come piace a te
[Non-text portions of this message have been removed]
I try to clairly explain you what I would like to have:
the problem is that I need for this strange arrangement since I have some tables that are "common table" and some other that depends of kind of "service" that has to be managed. So I have only one "master" db, and many "Service" db, I don't know how many "Service" db I can have, but each "Service" db will have all the master tables plus other tables. Again, all the Sevice tables that refer to master, must contains the same data for all the Service dbs. I have already created and tested an Delphi application that works on a Access database. Using the linked table, I'm able to obtain what I want, but since my database going to be "too big", you know that access will become unuseful (performance very slow). So I'd like to migrate to Firebird, but before that, I need to know if it meet to my aim. So, it's possible to simulate the "access linked manager" with interbase or firebird?
Many thanks
Antonio
ps: IBReplicator (or other similar tools ) I think can solve my broblem, but I'd like to solve this problem via "query" if possible
Helen Borrie <helebor@...> wrote:
I'm just extremely curious as to *why* you want to have such a
disintegrated and contradictory arrangement...and, moreover, why you think
that a RDBMS which is designed to *protect* integrity would be useful to
your design.
heLen
---------------------------------
MIo Yahoo! : personalizza Yahoo! come piace a te
[Non-text portions of this message have been removed]