Extract, Transform and Load from ODBC to Mysql

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?


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.

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

jeffrey_collins@hotmail.com wrote:
Quoted text here. Click to load it

Site Timeline