[ic] migrate

[Peter]

On 05/27/2008 06:16 PM, Darnell Hudson wrote:
> I have been working on this client site. I post about on here.
> I am moving this client from a php application which is creload and put
> them on interchange and I am using postgresql on interchange. So I need
> to migrate the data from mysql to postgresql. I need to move a lot of 
> product and
> the clients customers. Any Idea how to do this will be good. Just to let 
> you know this
> client has over 3,000 products and about 3,000 customers.


Yeah, what I have done in similar situations in the past is to write a 
perl script that uses DBI to connect to both databases simultaneously 
and transfer the data over munging it on the way so that it ends up in 
the format and the tables that IC likes.

You can get more info by reading up on the docs for DBI, DBD::mysql and 
DBD::pg.

Peter