To pause data migration for a table, choose the table in SSMS and then select the option Stretch | Pause. You can achieve the same with the following Transact-SQL command; it temporarily breaks the data migration for the T1 table:
USE Mila; ALTER TABLE dbo.T1 SET (REMOTE_DATA_ARCHIVE (MIGRATION_STATE = PAUSED));
To resume data migration for a table, choose the table in SSMS and then select the Stretch/Resume option or write the Transact-SQL code, similar to the following one:
USE Mila; ALTER TABLE dbo.T1 SET (REMOTE_DATA_ARCHIVE (MIGRATION_STATE = OUTBOUND));
To check whether migration is active or paused, you can open Stretch Database Monitor in SQL Server Management Studio and check the value of the Migration ...
