Re: Multi RDBMS queries...

2004-07-30 Thread Tim Howell
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

Re: Multi RDBMS queries...

2004-07-29 Thread Jeff Zucker
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

Re: Multi RDBMS queries...

2004-07-29 Thread Jeff Zucker
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

Multi RDBMS queries...

2004-07-29 Thread Tim Howell
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