Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Common Functionality › Define Volumetrics for a SQL Server Table

Define Volumetrics for a SQL Server Table

In a model based on a SQL Server 2008, 2012, 2014, or 2016 target server, you use the SQL Server Table Editor to define volumetrics for a table.

To define table volumetrics for a SQL Server table

1. Click Tables on the Model menu.

   The SQL Server Table Editor opens.

2. Select the table in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

3. Click the Volumetrics tab and work with the following options:

   Initial Row Count

   Defines row count for the table. Enter a value in the field.

   Max Rows

   Defines row sizing for the table. Enter a value in the field.

   Growth By Month

   Defines growth increments for the table. Enter a value in the field.

4. Click Close.

   Volumetrics are defined for the table and the SQL Server Table Editor closes.