mySQL to postgreSQL

Question

We are trying to switch our application from talking to mySQL to postgres. I wished we would have some kind of a subroutine (in VB6) were I can input the mySQl SQL query and get a string out containing the appropriate postgres query.

Does anybody have a solution or is interested working with us on that?

James McNellis · Accepted Answer · 2009-10-24 15:15:19Z

2

I would consult the "Comparison of Different SQL Implementations;" it's a most useful reference when converting queries from one RDBMS to another. WikiBooks also has a page entitled "Converting MySQL to PostgreSQL." It has a short list of the big differences between the two.

I don't know of any (free/open source) utility to translate queries, but unless you have really big, complicated queries, you shouldn't have much difficulty translating them (and, if you do have big, complicated queries, an automated tool probably won't help).

answered Oct 24, 2009 at 15:15

James McNellis

357k76 gold badges934 silver badges983 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Damon · Accepted Answer · 2009-10-24 15:32:07Z

1

I don't believe that there's any 'silver bullet' tool that would convert all of your queries from being MySQL to Postgres compatible.

What you do need is:

a reference of the differences between the two RDBMS (see @"James McNellis")
a good test plan for your application that will put it through the paces to ensure that your converted database backend works
a good reason to go through all this trouble; performance? management edict? etc.

answered Oct 24, 2009 at 15:32

Damon

6973 silver badges17 bronze badges

Collectives™ on Stack Overflow

mySQL to postgreSQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related