Enable Table for Stretch Database – Part 3

Enabling Stretch Database on a database or a table requires db_owner permissions. Enabling Stretch Database on a table also requires ALTER permissions on the table.

USE <DATABASE NAME>
GO
ALTER TABLE <table name> ENABLE REMOTE_DATA_ARCHIVE WITH ( MIGRATION_STATE = ON );
GO;
example:
use SQL2016DB
GO
ALTER TABLE t1 ENABLE REMOTE_DATA_ARCHIVE WITH (MIGRATION_STATE = ON );
GO

Once you enable the Table for Stretch SQL Server will deploy the table and send the data in batches to Azure Database,this will tell the status on no of rows migrated from source to destination

GO
select object_name(table_id) TableName,* from sys.dm_db_rda_migration_status
GO

S_2

Check if table and Data existing on Azure Database

S_3

 

Leave a Reply

Your email address will not be published. Required fields are marked *