sharadov
sharadov

Reputation: 1088

Need a tool to convert postgres database to mysql

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

Upvotes: 0

Views: 643

Answers (3)

user229544
user229544

Reputation:

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

Upvotes: 2

Magnus Hagander
Magnus Hagander

Reputation: 25078

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.

Upvotes: 3

longneck
longneck

Reputation: 12226

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

Upvotes: 1

Related Questions