 | | | Connect To Foreign Tables | Connect To Foreign Tables 2007-10-06 - By Rob Wultsch
Back
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 <werner@(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
wultsch@(protected) (email/google im)
wultsch (aim)
wultsch@(protected) (msn)
|
|
|