Need a tool to convert postgres database to mysql

Question

I found the mysql migration toolkit which will migrate the tables.But is there something which will convert the functions as well.

Magnus Hagander · Accepted Answer · 2009-09-03 07:36:54Z

3

Almost certainly not.

If your functions are in the SQL language only, it should probably be doable. But any of the many other languages supported by PostgreSQL (pl/pgsql, perl, python etc) are completely different, and contain much functionality that's simply not supported on MySQL.

answered Sep 3, 2009 at 7:36

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

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

Comments

Lekensteyn · Accepted Answer · 2012-12-23 20:50:25Z

2

There are several data migration tools available on Google to convert database. I use dbload for example.

edited Dec 23, 2012 at 20:50

Lekensteyn

67k25 gold badges169 silver badges205 bronze badges

answered Dec 11, 2009 at 10:45

user229544

Comments

longneck · Accepted Answer · 2009-09-02 22:09:31Z

1

most likely not. the stored procedure and function language differs greatly between postgresql and mysql. such an application would be costly to develop.

answered Sep 2, 2009 at 22:09

longneck

12.3k3 gold badges39 silver badges49 bronze badges

Collectives™ on Stack Overflow

Need a tool to convert postgres database to mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related