The open source bridge for data migration and warehousing
Say goodbye to the headache of database migration - RosettaDB makes it simple to migrate your schema to any target database. With RosettaDB, you can easily replicate your database in multiple targets, ensuring your data is always available exactly where you need it.
Key Features
Migrate your Databases
Migrate your Databases to Cloud
Database Test Framework
Database Test Framework
Declarative Data Modeling
Migrate data objects across data platforms.
DBT Model Generator
Generate DBT models from your source
databases for easy transformations
Generate DDL
Generate DDL from a given source and transpile to the desired target.
Custom translator support
Custom translator support via translation CSV file extension/creation
CI/CD
CI/CD integrations for Data Modeling
DAC (Database As Code)
Define database structures in YAML and automate deployment via CI/CD
Multi-database support
Support for multiple databases:
Supported Databases
Declarative Data Modeling – where complexity meets simplicity. With its focus on the ‘what’ instead of the ‘how’, declarative data modeling allows you to define your database schema in a more intuitive and natural way. By abstracting away the implementation details, you can create rich, meaningful models that are easy to understand and maintain. Say goodbye to the headaches of manual schema management and hello to the power of declarative data modeling
---
databaseType: bigquery
operationLevel: database
tables:
- name: "profiles"
type: schema: "breathe"
columns:
- name: "id"
typeName: "INT64"
jdbcDataType: "4"
ordinalPosition: 0
primaryKeySequenceId: 1
columnDisplaySize: 10
scale: 0
precision: 10
primaryKey: false
- name: "name"
typeName: "STRING"
jdbcDataType: "12"
ordinalPosition: 0
primaryKeySequenceId: 0
columnDisplaySize: 255
scale: 0
precision: 255
primaryKey: false
DOCUMENTATION
ROSETTADB DOCUMENTATION
GITHUB