Re: Query Across DBMS Boundaries (Linked Database Servers?)

Dee Ayy wrote:

Is there something which can perform a query across different database systems? It would extend the database.table.field notation to maybe dbms.database.table.field and allow queries across MySQL and MSSQL

I don't think so. Both mysql and mssql would need to know how to parse that syntax and make it all work (besides other problems like database permissions, different connection strings and so on). Depending on how much data you are looking to move from one to the other, you could get mssql to export to a csv file (if it supports it - no idea) then get mysql to import it. Either use the csv storage engine (http://dev.mysql.com/doc/refman/4.1/en/csv-storage-engine.html) or load it into another table using 'load data infile' (http://dev.mysql.com/doc/refman/4.1/en/load-data.html). If you need to do it on the fly, my only other suggestion would be to set up two database connections - one for mssql and one for mysql and aggregate the data in php. -- Postgresql & php tutorials http://www.designmagick.com/