Re: [gnome-db] filemaker and mysql in unix odbc or gnomedb/mergeant

[Rodrigo Moya <rodrigo gnome-db org>]

On Sun, 2003-11-23 at 20:57, Eric wrote:
> We need a temporary and long term solution for inserting data to a mysql
> table
> from a filemaker table, something like this:
> INSERT INTO mysqltable (first, last, id) SELECT First_Name, Last_Name,
> Customer_ID from filemakertable . I have been looking everywhere for a
> solution
> and thought you may have some input. Without using the unixodbc odbc
> $bridge, will this
> work. All of the sql gui clients I have found so far wont let me insert
> from a
> table that is not in the same database. Will "unixodbc DataManager" let us
> execute sql
> like this example? We have OSX Darwin at our disposal with mysql, apache,
> php,
> odbc, filemaker server, filemaker unlimited and odbc drivers for all
> three. Will mergeant/gnomedb allow us to use odbc data sources?
> 12344321 nicholse

gnome-db does not support yet filemaker files, so we need that provider
written first. Then, you could write a program that reads the filemaker
tables and import them on the mysql database.

Would that fix resolve your problems?

cheers