From: ow <oneway_111@yahoo.com>
To: pgsql-hackers@postgresql.org
Subject: Re: Are we losing momentum?
Date: Wed, 16 Apr 2003 05:20:17 -0700 (PDT)
Message-ID: <20030416122017.38532.qmail@web21409.mail.yahoo.com> (raw)
In-Reply-To: <20030416002826.03277586AB@cbbrowne.com>
> BTW, DB2 doesn't have 'em [cross-db queries] either.
> In DB2, you can of course have cross-schema queries but no cross-db
> queries, unless you rig up the federated functionality to connect one
> db to the other.
A while ago I was at a client who wanted to migrate to DB2 and this
questions was raised during discussions with IBM. There was a way to do
this, if I remember correctly the solution involved creating views for
all tables from db2 that you wanted to use in db1 and maybe something
else. Can't tell you for sure, I'm not working with DB2.
Oracle, Sybase, Ms, Informix (? AFAIK) , mySql, they all support
cross-db queries.
Anyway, I thought it was important to bring this up. With large number
of apps and large amount of data having everything in one db is a sure
way for disaster, IMHO.
__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: oneway_111@yahoo.com
Subject: Re: Are we losing momentum?
In-Reply-To: <20030416122017.38532.qmail@web21409.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox