Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
September 11, 2006, 6:59 pm
rate this thread
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]
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum