| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Bill P(dot)" <maxarbos(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Migration from MySQL to PostgreSQL : Datatypes? |
| Date: | 2010-12-23 17:38:50 |
| Message-ID: | AANLkTi=xvvpdFxRSGFMkP68dE9F3ds7TR-nO_xCuhLH1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Dec 23, 2010 at 9:12 AM, Bill P. <maxarbos(at)yahoo(dot)com> wrote:
> I found a program called easyfrom, but it's over $200 and only runs on
> windows. Navicat, which i have, doesnt seem to have any provision to change
> the datatypes on structure sync from one to the other types of db.
>
> Any suggestions would be great.
> thanks.
It sounds like you need a tool to extract, transform, and then load
(ETL) from Mysql to Postgresql. There are many application that will
do this for you.
Pentaho:Kettle - is a java application that should work for you:
http://sourceforge.net/projects/pentaho/
--
Regards,
Richard Broersma Jr.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2010-12-23 17:50:10 | Re: Migration from MySQL to PostgreSQL : Datatypes? |
| Previous Message | Aarni | 2010-12-23 17:38:47 | Re: Migration from MySQL to PostgreSQL : Datatypes? |