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 Server depending on the id of the record from the people table.
I realize that a multi- system query wouldn't enjoy most of the
optimization that should be handled by the DBMS, but I'm thinking of
what would make things cleaner conceptually when performing these kind
of queries.
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, unmodified, against that DB.
Are there as many reasons that this won't work as I imagine there might
be?
Thanks! =)
--TWH
