Sql Server Assessments
This section describes individual premigration assessments for migration tasks that use a Microsoft SQL Server source endpoint.
To create an individual premigration assessment using the Amazon DMS API, use the listed API key for the Include
parameter of the
StartReplicationTaskAssessmentRun action.
Check if recovery model for database is simple
API key: sqlserver-check-for-recovery-model
This premigration assessment validates the source endpoint recovery model. Amazon DMS requires that the recovery model
be set to Bulk logged or Full for ongoing replication.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Prerequisites for using ongoing replication (CDC) from a SQL Server source.
Check if tables in task scope contain computed columns
API key: sqlserver-check-for-computed-fields
This premigration assessment checks for the presence of computed columns. Amazon DMS doesn't support replicating changes from SQL Server computed columns.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if tables in task scope have column store indexes
API key: sqlserver-check-for-columnstore-indexes
This premigration assessment checks for the presence of tables with columnstore indexes. Amazon DMS doesn't support replicating changes from SQL Server tables with columnstore indexes.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if memory optimized tables are a part of the task scope
API key: sqlserver-check-for-memory-optimized-tables
This premigration assessment checks for the presence of memory-optimized tables. Amazon DMS doesn't support replicating changes from memory-optimized tables.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if temporal tables are a part of the task scope
API key: sqlserver-check-for-temporal-tables
This premigration assessment checks for the presence of temporal tables. Amazon DMS doesn't support replicating changes from temporal tables.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if delayed durability is enabled at the database level
API key: sqlserver-check-for-delayed-durability
This premigration assessment checks for the presence of delayed durability. Amazon DMS doesn't support replicating changes from transactions that use delayed durability.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if accelerated data recovery is enabled at the database level
API key: sqlserver-check-for-accelerated-data-recovery
This premigration assessment checks for the presence of accelerated data recovery. Amazon DMS doesn't support replicating changes from databases with accelerated data recovery.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information, see Limitations on using SQL Server as a source for Amazon DMS.
Check if table mapping has more than 10K tables with primary keys
API key: sqlserver-check-for-accelerated-data-recovery
This premigration assessment checks for the presence of more than 10,000 tables with primary keys. Databases configured with MS-Replication can experience task failures if there are too many tables with primary keys.
This assessment is only valid for a full-load and CDC migration, or a CDC-only migration. This assessment is not valid for a full-load only migration.
For more information about configuring MS-Replication, see Capturing data changes for self-managed SQL Server on-premises or on Amazon EC2.