ScaleArc DB Migration utilizes AWS Database Migration Service (DMS) which is responsible for the migration of tables and primary schema.
Several limitations imposed by DMS are valid for our service too. Hence, 100% structural parity cannot be guaranteed.
Support
On top of DMS, our tool supports migrating the following schema properties (listed below).
|
Property |
Support |
|
Auto Increment |
Supported |
|
Indexes |
Supported |
|
Foreign Keys |
Supported |
|
Views |
Supported |
|
Stored Procedures |
Supported |
|
Row Format |
Supported |
|
Default Values |
Supported |
|
Unique Constraint |
Supported |
|
Table comments (or remarks) |
Supported |
|
Triggers |
Supported |
|
Timestamp datatype |
Supported |
|
ENUM datatype |
Supported |
|
SET datatype |
Supported |
|
Generated columns |
Partially Supported (Converted to a regular column with base datatype) |
|
LOB columns in non-pk tables |
Partially supported (for Non-CDC tasks) |