Extract, Transform and Load from ODBC to Mysql

We have an old legacy database at my company called CIMPRO, running on
a SCO UNIX box. We're trying to find a way to connect to the CIMPRO
database, grab the data, and send it to a Mysql database.

I've been able to successfully connect to the database using PHP and
ODBC to view the data in the tables.

I'd like to find a way to run a Linux tool or script to connect to the
database, do an initial copy of the table structure from the legacy
database to Mysql (on the linux box) and then copy selected data.

If that is doable I'd also like to be able to refresh the table data
periodically (e.g., cron job) either by deleting and reimporting or by
checking to see what has changed.

Does anyone know of a tool out there that would accomplish this?

Thanks
Jeff

Re: Extract, Transform and Load from ODBC to Mysql

You could try the SQL SELECT INTO Statement

The SELECT INTO statement is most often used to create backup copies of
tables or for archiving records.
Syntax

SELECT column_name(s) INTO newtable [IN externaldatabase]
FROM source



jeffrey_collins@hotmail.com wrote:
> We have an old legacy database at my company called CIMPRO, running on
> a SCO UNIX box. We're trying to find a way to connect to the CIMPRO
> database, grab the data, and send it to a Mysql database.
>
> I've been able to successfully connect to the database using PHP and
> ODBC to view the data in the tables.
>
> I'd like to find a way to run a Linux tool or script to connect to the
> database, do an initial copy of the table structure from the legacy
> database to Mysql (on the linux box) and then copy selected data.
>
> If that is doable I'd also like to be able to refresh the table data
> periodically (e.g., cron job) either by deleting and reimporting or by
> checking to see what has changed.
>
> Does anyone know of a tool out there that would accomplish this?
>
> Thanks
> Jeff