Re: [GENERAL] Mysql migration to Postgresql

2009-11-27 Thread Cjkalbente
As said by Filip RembiaƂkowski-3, you could try using some software that will help you in managing the transfer. I can recommend the use of data integration software such as Datastage (It is a licensed program) or Talend Open Studio (Talend is open source). Tell us how it went. mrciken wrote:

Re: [GENERAL] Mysql migration to Postgresql

2009-11-25 Thread Craig Ringer
mrciken wrote: > Hello, > > Currently, we are using Mysql: we would like to change. Now, we would like > to use Postgresql. Only problem is that most of our customer addresses and > other information are on Mysql. > Can you help us with this? There are a few options available to you. This has b

Re: [GENERAL] Mysql migration to Postgresql

2009-11-25 Thread Filip RembiaƂkowski
this was a very general question. you can use any ETL / script to transfer data from mysql to postgres. for me, sometimes, the following path works: 1. first try to dump the mysql database SQL schema in ANSI-conformant format (consult mysql support how to do it). import this into fresh postgres