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:
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
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