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 wrote:
> Hi Chiranjeevi,
>
> I know my answer doesn't answer your request but we have just
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 tab
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
Thank you All.
On Mon, Jun 25, 2018 at 3:40 PM, Adrian Klaver
wrote:
> On 06/25/2018 09:47 AM, chiru r wrote:
>
>> Hi All,
>>
>>
>> Please suggest Schema/Data conversion opensource tools from MySQL to
>> PostgreSQL.
>>
>>
> To add to the list:
>
> pgloader:
>
> http://pgloader.readthedocs.io/en/
On 06/25/2018 09:47 AM, chiru r wrote:
Hi All,
Please suggest Schema/Data conversion opensource tools from MySQL to
PostgreSQL.
To add to the list:
pgloader:
http://pgloader.readthedocs.io/en/latest/tutorial/tutorial.html#migrating-from-mysql-to-postgresql
Thanks,
Chiranjeevi
--
Ad
chiru r schrieb am 25.06.2018 um 18:47:
Please suggest Schema/Data conversion opensource tools from MySQL to PostgreSQL.
ora2pg also supports MySQL: https://github.com/darold/ora2pg
ailing List"
Subject: [External] Re: Schema/Data conversion opensource tools from MySQL to
PostgreSQL
Hi Chiru,
You can use MySQL foreign data wrapper to achieve this.
Regards,
Pavan
On Mon, Jun 25, 2018, 10:18 PM chiru r
mailto:chir...@gmail.com>> wrote:
Hi All,
Please suggest
Can you explain what you're looking for? Beyond manually editing the schema
dump to import correctly into postgres and the loading in INSERT dumps or
MySQL file (TSV?) dumps, what are you looking for? Do you have any
odd/incompatible data types?
Jim
On Mon, Jun 25, 2018 at 11:47 AM, chiru r wrot
Hi Chiru,
You can use MySQL foreign data wrapper to achieve this.
Regards,
Pavan
On Mon, Jun 25, 2018, 10:18 PM chiru r wrote:
> Hi All,
>
>
> Please suggest Schema/Data conversion opensource tools from MySQL to
> PostgreSQL.
>
>
> Thanks,
> Chiranjeevi
>
