SQL Server Schema Support

ScaleArc DB Migration utilizes AWS Database Migration Service (DMS). It is responsible for the migration of tables and primary schemas.

All the 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	Supported
Identity columns	Supported
Indexes	Supported
Foreign Keys	Supported
Default Values	Supported
Check Constraints	Supported
Unique Constraints	Supported
Views	Supported
Synonyms	Supported
Stored Procedures	Supported
Functions	Supported
Triggers	Supported
Computed columns without User Defined functions with User Defined functions	Supported Partially Supported (target columns are converted to corresponding base data type columns with data intact)
LOB columns in non-pk tables	Partially supported (for Non-CDC tasks)
Timestamp columns	Partially supported (property intact with new timestamps generated in the target columns)
Schemas	Partially supported (empty schemas, with no db objects are not migrated)