RosettaDB
Declarative Database Management - DDL Transpiler
Overview
Rosetta is a declarative data modeler and transpiler that converts database objects from one database to another. Define your database in DBML and rosetta generates the target DDL for you.
Rosetta utilizes JDBC to extract schema metadata from a database and generates declarative DBML models that can be used for conversion to alternate database targets.
Generate DDL from a given source and transpile to the desired target.
Currently, supported databases and translations are shown below in the table.
| BigQuery | Snowflake | MySQL | Postgres | Kinetica | Google Cloud Spanner | SQL Server | DB2 | Oracle | |
|---|---|---|---|---|---|---|---|---|---|
| BigQuery | / | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Snowflake | ✅ | / | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| MySQL | ✅ | ✅ | / | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Postgres | ✅ | ✅ | ✅ | / | ✅ | ✅ | ✅ | ✅ | ✅ |
| Kinetica | ✅ | ✅ | ✅ | ✅ | / | ✅ | ✅ | ✅ | ✅ |
| Google Cloud Spanner | ✅ | ✅ | ✅ | ✅ | ✅ | / | ✅ | ✅ | ✅ |
| SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | / | ✅ | ✅ |
| DB2 | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | / | ✅ |
| Oracle | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | / |