| title | sys.dm_db_rda_migration_status (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.reviewer | |||||
| ms.technology | stored-procedures | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | faf3901c-a0e0-4e0c-8b1b-86d9f15f34dd | ||||
| author | pmasl | ||||
| ms.author | pelopes |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]
Contains one row for each batch of migrated data from each Stretch-enabled table on the local instance of [!INCLUDEssNoVersion]. Batches are identified by their start time and end time.
sys.dm_db_rda_migration_status is scoped to the current database context. Make sure you're in the database context of the Stretch-enable tables for which you want to see migration status.
In [!INCLUDEssSQL15], the output of sys.dm_db_rda_migration_status is limited to 200 rows.
| Column name | Data type | Description |
|---|---|---|
| table_id | int | The ID of the table from which rows were migrated. |
| database_id | int | The ID of the database from which rows were migrated. |
| migrated_rows | bigint | The number of rows migrated in this batch. |
| start_time_utc | datetime | The UTC time at which the batch started. |
| end_time_utc | datetime | The UTC time at which the batch finished. |
| error_number | int | If the batch fails, the error number of the error that occurred; otherwise, null. |
| error_severity | int | If the batch fails, the severity of the error that occurred; otherwise, null. |
| error_state | int | If the batch fails, the state of the error that occurred; otherwise, null. The error_state indicates the condition or location where the error occurred. |