Re: Cross-Database query engine?

At 10:44 PM -0500 7/24/07, David Nicol wrote:
So you're saying that Access abstracts the handles to the multiple databases
in such a way that they appear to you as a single database, and you can use the
tools the way you would use on a single database on the combination of the
multiple databases.

If that's the case, making several dbs look like one, then some DBMS can already do that internally. At the very least, Oracle, MySQL, and SQLite can all do that, afaik.

Since MySQL is what you say you want to use, I recommend looking into the "Federated" storage engine that MySQL offers, which is in the current 5.0.x series and later; tables of that engine are proxies for tables under some other server. Not all SQL features are supported with them, but the ones that are may be enough.

http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html

-- Darren Duncan
.