Convert a schema from one database to another
ERD Designer converts a schema in any direction between nine databases. Paste the DDL, see it as a diagram, change its target database, and review every column's new datatype before it is applied. Where the target offers more than one fair answer, it asks; where something is lost, it says so.
Choose a direction
Rows are the database you are converting from, columns the one you are converting to.
| From \ To | PostgreSQL | Oracle | SQL Server | MySQL | MariaDB | SQLite | Amazon Redshift | Google BigQuery | Snowflake |
|---|---|---|---|---|---|---|---|---|---|
| PostgreSQL | — | → | → | → | → | → | → | → | → |
| Oracle | → | — | → | → | → | → | → | → | → |
| SQL Server | → | → | — | → | → | → | → | → | → |
| MySQL | → | → | → | — | → | → | → | → | → |
| MariaDB | → | → | → | → | — | → | → | → | → |
| SQLite | → | → | → | → | → | — | → | → | → |
| Amazon Redshift | → | → | → | → | → | → | — | → | → |
| Google BigQuery | → | → | → | → | → | → | → | — | → |
| Snowflake | → | → | → | → | → | → | → | → | — |
- PostgreSQL to Oracle, SQL Server, MySQL, MariaDB, SQLite, Amazon Redshift, Google BigQuery, Snowflake
- Oracle to PostgreSQL, SQL Server, MySQL, MariaDB, SQLite, Amazon Redshift, Google BigQuery, Snowflake
- SQL Server to PostgreSQL, Oracle, MySQL, MariaDB, SQLite, Amazon Redshift, Google BigQuery, Snowflake
- MySQL to PostgreSQL, Oracle, SQL Server, MariaDB, SQLite, Amazon Redshift, Google BigQuery, Snowflake
- MariaDB to PostgreSQL, Oracle, SQL Server, MySQL, SQLite, Amazon Redshift, Google BigQuery, Snowflake
- SQLite to PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, Amazon Redshift, Google BigQuery, Snowflake
- Amazon Redshift to PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, SQLite, Google BigQuery, Snowflake
- Google BigQuery to PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, SQLite, Amazon Redshift, Snowflake
- Snowflake to PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, SQLite, Amazon Redshift, Google BigQuery
Each page shows a sample schema converted, the questions the conversion asks, its warnings and the script it generates. Every direction is applied to a real server of the target database by our test suite.
Which plan you need
Pasting a script and working with it as a diagram is free on the Basic plan, with no card. Converting a diagram to another database is part of the Pro and Advanced plans.
Questions? Write to support@erddesigner.com. · Terms · Privacy