MySQL to PostgreSQL converter

#1

Post by mihailshumilov » Sat, Feb 28, 2015, 12:50 PM UTC

MySQL to PostgreSQL converter
github.com

Re: MySQL to PostgreSQL converter

#2

Post by bjacobel » Sat, Feb 28, 2015, 2:34 PM UTC

No foreign key support is kind of a deal-breaker. Hard to believe anyone who is actually in the position of needing this would have a schema so simple that it contains no foreign keys.

Re: MySQL to PostgreSQL converter

#3

Post by warbiscuit » Sat, Feb 28, 2015, 2:42 PM UTC

bjacobel wrote: post #2

No foreign key support is kind of a deal-breaker. Hard to believe anyone who is actually in the position of needing this would have a schema so simple that it contains no foreign keys.

Hard to believe mysql doesn't include that data in one of it's dump formats.

Re: MySQL to PostgreSQL converter

#4

Post by morgo » Sat, Feb 28, 2015, 2:45 PM UTC

warbiscuit wrote: post #3

bjacobel wrote: post #2

No foreign key support is kind of a deal-breaker. Hard to believe anyone who is actually in the position of needing this would have a schema so simple that it contains no foreign keys.

Hard to believe mysql doesn't include that data in one of it's dump formats.

It is supported, just not in XML dump format.

Re: MySQL to PostgreSQL converter

#5

Post by warbiscuit » Sat, Feb 28, 2015, 2:55 PM UTC

morgo wrote: post #4

warbiscuit wrote: post #3

Earlier quoted context omitted.

Hard to believe mysql doesn't include that data in one of it's dump formats.

It is supported, just not in XML dump format.

Ah. That's a relief, I was a little worried. But that makes it strange that someone, knowing of this limitation, would choose to start with the xml dump format.

Re: MySQL to PostgreSQL converter

#6

Post by chris_wot » Sat, Feb 28, 2015, 3:03 PM UTC

morgo wrote: post #4

warbiscuit wrote: post #3

Earlier quoted context omitted.

Hard to believe mysql doesn't include that data in one of it's dump formats.

It is supported, just not in XML dump format.

How?

Re: MySQL to PostgreSQL converter

#7

Post by barking » Sat, Feb 28, 2015, 3:10 PM UTC

warbiscuit wrote: post #5

morgo wrote: post #4

Earlier quoted context omitted.

It is supported, just not in XML dump format.

Ah. That's a relief, I was a little worried. But that makes it strange that someone, knowing of this limitation, would choose to start with the xml dump format.

I think the fact that this form of dump doesn't contain foreign keys is even more extraordinary.

What's the point of having a dump format that you can't use to restore your database properly?

Does it have a health warning advising that it's not a proper dump?

Re: MySQL to PostgreSQL converter

#8

Post by jeltz » Sat, Feb 28, 2015, 3:13 PM UTC

I would recommend using pgloader (http://pgloader.io/) instead. It is simple to use in the default case, but can be configured with rules for how data types should be converted if necessary. It can also clean up weird timestamps like 0000-00-00 00:00:00.