v2.0
- About MDB
- Installation
- Upgrade
- Concepts
- User Interface
- Source Requirements
- Target Database Requirements
- Target Kafka Requirements
- Usage Restriction
- Frequently Exceptions
- Release Note
MDB Introduction
MDB (MogDB Data Bridge) is a heterogeneous database migration and synchronization tool.
It is used for database migration and synchronization between MogDB/openGauss or openGauss-based databases and other databases such as Oracle, DB2, MySQL.
Architecture
Supported Database Types
| Source Database | Target database | Supported or Not |
|---|---|---|
| Oracle | MogDB | Supported |
| MySQL | MogDB | Supported |
| PostgreSQL | MogDB | Supported |
| DB2 | MogDB | Support only structure and snapshot |
| MogDB | MogDB | Supported |
| MogDB | Oracle | Supported |
| MogDB | MySQL | Supported |
| MogDB | DB2 | Supported |
| MogDB | kafka | Supported |
| Oracle | GaussDB | Supported |
| MySQL | GaussDB | Supported |
| DB2 | GaussDB | Support only structure and snapshot |
| MogDB | GaussDB | Supported |
| GaussDB | Oracle | Supported |
| GaussDB | DB2 | Supported |
Supported Database Objects
| Object Name | Supported or Not | Description |
|---|---|---|
| Schema | Supported | |
| Table | Supported | |
| Constraint | Unsupported | Foreign key unsupported |
| Index | Supported | |
| TableData | Supported | Table data |
| User | Unsupported | |
| Sequence | Supported | |
| Synonyms | Supported | |
| Trigger | Supported | Only supported Oracle, MySQL |
| Procedure | Supported | Only supported Oracle, MySQL |
| Function | Supported | Only supported Oracle, MySQL |
| View | Supported | Only supported Oracle, MySQL |
| Package | Supported | Only supported Oracle |