Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL

Thank you for your inputs...

I am looking for tool to reduce the manualy effort in Migration. I
undestand manual efforts needed to migare 100% to PostgreSQL.

On Tue, Jun 26, 2018 at 4:08 AM, Thomas Poty <thomas(dot)poty(at)gmail(dot)com> wrote:

> Hi Chiranjeevi,
>
> I know my answer doesn't answer your request but we have just converted a
> database from mysql to postgresql with about 1000 tables.
> We had to convert some functions present in mysql but not in postgresql
> Also we had to convert queries.
> I converted all of that manually, table by table, column by column,etc
>
> We developped a program that compare structure , a program that migrate
> data and a program that compare data.
> Also we had to convert queries.
>
> All of that to say I don't think you can convert only by running a tool
> like that.
>
> I also think it is a bit difficult to suggest a tool without knowing
> exactly what is needed.
>
> Regards
> Thomas
>
>
> Le mar. 26 juin 2018 à 08:25, Arnaud L. <arnaud(dot)listes(at)codata(dot)eu> a
> écrit :
>
>> Le 25-06-18 à 18:47, chiru r a écrit :
>> > Please suggest Schema/Data conversion opensource tools from MySQL to
>> > PostgreSQL.
>>
>> Hi.
>> I used this php script which did a pretty good job :
>> https://github.com/AnatolyUss/FromMySqlToPostgreSql
>>
>> --
>> Regards
>>
>>