Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.poty@xxxxxxxxx> 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.listes@xxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux