To enable Stretch DB for a table, you can also choose between the wizard and Transact-SQL. You can migrate an entire table or just part of a table. If your cold data is stored in a separated table, you can migrate the entire table; otherwise you must specify a filter function to define which rows should be migrated. To enable the Stretch DB feature for a table, you must be a member of the db_owner role. In this section, you will create a new table in the Mila database, populate it with a few rows, and enable it for stretching. Use this code to create and populate the table:
USE Mila; CREATE TABLE dbo.T1( id INT NOT NULL, c1 VARCHAR(20) NOT NULL, c2 DATETIME NOT NULL, CONSTRAINT PK_T1 PRIMARY KEY CLUSTERED ...