How to convert MySQL script to plain SQL?

Question

Is there a way/tool to convert a MySQL script to plain SQL? I design my databases on MySQL with their tools but I'm trying to use Flyway to handle migrations. I would like to have the script on plain SQL so it applies to any Data base.

I know I can translate my scripts to plain SQL, I'm looking for a way to automate this in order to avoid redoing this each time the database model has to change for some reason.

Any idea?

Kermit · Accepted Answer · 2012-08-30 18:20:53Z

2

phpMyAdmin has a format option to try to output an export in DB2, MSSQL, Oracle, Traditional.

answered Aug 30, 2012 at 18:20

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

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

2 Comments

javydreamercsw Over a year ago

This is a way indeed. Hard to use from Java or such, but I did't specify it on the question.

Kermit Over a year ago

@javydreamercsw Sorry I couldn't be of more assistance.

Collectives™ on Stack Overflow

How to convert MySQL script to plain SQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related