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 to multiple targets, ensuring your data is always consistant across database environments.
Key Features
Migrate your Databases
Migrate from one database to another, or from on-prem to cloud.
Database Test Framework
Testing framework that empowers you to thoroughly test your data and instill confidence in its accuracy and reliability.
Declarative Data Modeling
Simplify data modeling with declarative efficiency.
DBT Model Generator
Generate DBT models from your source databases for easy transformations.
Generate DDL
Extract DDL from a given source and transpile for a desired target.
Custom Translator Support
Extensible translation support. Seamlessly customize and integrate your own translators.
CI/CD
Easily integrate with your CI/CD platform for Data Pipelines.
DAC (Database As Code)
Define database structures in YAML and automate deployment via CI/CD.
Multi-database Support
Supports the most popular relational and cloud databases.
Supported Databases
Declarative Data Modeling
Declarative Data Modeling is 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
Geting started
- Initialzie a project
- Configure you data source connections
- Extract model from source DB
- Add or update you target model
- Transpile and deploy model to target DB
Documentation
To learn more about how you can use Rosetta, please visit our community page or reach out to us directly. We look forward to hearing from you!
GitHub
The project is hosted on GitHub, where you can find the latest source code,documentation, and community resources. As an open-source project.