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
Check if table and Data existing on Azure Database