On 11/16/05, Shawn <[EMAIL PROTECTED]
> wrote:
Hi Adil.
Here's a php script I wrote that does something similar to what you are after.
I wrote this to convert data from postgresql to mysql , for the database of
Drupal (content management system). It uses PearDB, so as long as you can
create a valid connection string, almost any database can be used (I'm not
tooooo familiar with Progress DBs.) The script assumes the table structures
on either server are similar.
So, it has to run on a box that has PHP with PearDB support, and the
appropriate database modules enabled. Use the fixfields() function to handle
cases where field names have been changed.
The code was written as a quick one-off type of thing, so is not fully
commented, or resistant to abuse. It won't trap every possible error it
might find.
I have used similar techniques to migrate data from MSSQL server to MySQL, so
I know it can be used to talk to a windows box...
HTH
Shawn
On Wednesday 16 November 2005 11:16, Adil Kodian wrote:
> hi folks
> Is there someone that can convert a progress database to MYSQL ?
> The Progress db runs on a windows box and the MySQL runs on a FC4 box.
> The idea is to write a cron-job that constantly reads from the progress
> database and writes to the MySQL. The script has to run on the linux box.
> Adil.
im a database newbie - so as i gather, if i use pear db i dont need the merant ODBC driver or anything - however does pear DB support progress or does it not matter ?
_______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
