Have you guys thought about trying to use a Federated table? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
Probably not exactly the solution you want, but maybe useful. On 10/6/07, Werner Van Belle <[EMAIL PROTECTED]> wrote: > > 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/ > > -- Rob Wultsch (480)223-2566 [EMAIL PROTECTED] (email/google im) wultsch (aim) [EMAIL PROTECTED] (msn)
