Hello, On Friday 05 October 2007 01:11:35 James Card wrote: > The application I'm working on uses MySQL 5.0.41 and we also need to > retrieve some data from a SQL-Server database in another department. > SQL-Server has a feature (that I haven't tested) that allows it to make an > ODBC connection to a foreign database and treat its tables as if they were > local. > > Is there any way to accomplish something similar in MySQL? I'd love to be > able to create a view that joins data from my local tables with that from > SQL_Server.
Did you get any response ? I'm quite interested in this question too. Recently I had to join around 1 G of local data with the genome databases in Germany and found that I either had to upload 1G of data to a temporary table or download 54G of data. Neither was particularly inspiring, so it would have been nice if I could just use various databases through the same local server. Are there any solutions for this kind of problem ? Werner,- -- Dr. Werner Van Belle http://werner.sigtrans.org/
signature.asc
Description: This is a digitally signed message part.
