Wonderful. It's always nice when you find out that, not only does your
idea have merit, but someone else has already figured out the details.
Time to start refactoring...
--TWH
On Jul 29, 2004, at 6:06 PM, Jeff Zucker wrote:
Tim Howell wrote:
> Does anyone know of a module that allows querie
Jeff Zucker wrote:
$dbh->ad_import('fruit_name' ,'DBI',DBI->connect( $dsn{odbc} ));
$dbh->ad_import('fruit_color','DBI',DBI->connect( $dsn{sqlite} ));
I forgot to mention that if you pass SQL queries to the ad_import()
calls, you can import only the rows and columns you are interested in,
rathe
Tim Howell wrote:
Does anyone know of a module that allows queries to be executed across
databases running on multiple RDBMSs?
One option I've thought of is to do really simple parsing of the SQL,
and then building a temporary DB in memory on one of the DBMSs, then
running the query, unmodifi
Does anyone know of a module that allows queries to be executed across
databases running on multiple RDBMSs? It's not terribly elegant, but I
have situations where I need to run a query that pulls information from
a people table, and then grabs addresses and stuff either from MySQL or
MSSQL Se