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

[GENERAL] Mysql migration to Postgresql

2009-11-25 Thread mrciken
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? Thank you. -- View this message in context: http://old.nabble.com/Mysql-mig