Hello Marius,

Thursday, June 5, 2003, 3:18:05 PM, you wrote:

MP> sorry for the first email
MP> What i want to ask is about connecting to muliple
MP> databases in interbase , it is possible to be
MP> implemented into firebirdsql ?
MP> Here is what a user is asking about this feature
MP> "joining and copying across multiple databases
MP> I need to store my tables in two (or more) separate
MP> database files, and make queries across them. Does
MP> interbase let you do this, and if so, what does the
MP> syntax look like?
MP> I also need to be able to copy data across the
MP> databases like this:
MP> INSERT INTO ...(table in database A)... SELECT
MP> ....(data in database B)...
MP> Is that possible? If it matters, i'm doing all this
MP> through JDBC."
MP> here is the rest of the thread

MP> http://forums.devshed.com/t63230/s.html

I've asked that question myself and many others, and still I couldn't
find those discussions. I know Ann gave a good point as to why it
wasn't implemented yet.

But, I think with the introduction of aliases in FB 1.5, it might be
one small step forward for this feature to be implemented. But,
there's a lot more work to do to get there. If my memory serves me
well, the biggest hurdle in cross database selection is to be able to
get the proper optimization of the data retrieval and proper
synchronization of the data retrieval between the databases, and
having a common cache between the databases for the result set.

So I believe that the task at hand is not small and would require
quite some work and a very good knowledge of the engine.

--
Best regards,
Daniel Rail