Enabling Stretch DB for a table by using wizard

You can create a new table with the Stretch DB feature enabled or enable it for an existing table using the Enable Table for Stretch wizard. To launch it, you need to navigate to the T1 table under the database Mila in SSMS. Then, after right-clicking, you need to select the option Tasks/Stretch/Enable respectively. You should get a following screenshot:

Enable Table for Stretch Wizard—Select tables

As you can see, T1 can be selected for stretching, since it meets the Stretch DB requirements discussed in the previous sections. You can choose to migrate the entire table or (by clicking on the link Entire Table) only a part of it. When you click on the link, you'll get this screen:

Enable Table for Stretch Wizard—Select rows to stretch

You see a query builder that can help you to write the correct filter function. Filter function is used to define which rows have to be migrated to the cloud. In this example, you are going to return all rows from the T1 table, where the value in the c2 column is less than 2018/02/01.

However, developers find query builders a bit clumsy, and most of them prefer to work with Transact-SQL. In the next section, you will see how to use Transact-SQL to configure Stretch DB.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.148.105