Page Comparison

...

There are several ways to add entities and indexes to filegroups in Aptify:

• Addding Entities to FilegroupsMultiple
• Adding Additional Base Tables to FilegroupsMultiple Filegroups
• Adding Text and Images to Filesgroups

Anchor
Adding Entities to Filegroups Adding Entities to Filegroups

Adding Entities to Filegroups

Follow these steps to add a new or existing entity to a filegroup:

1. Open a new or existing Entities record.
2. Open the Configurations tab.
3. Using the drop-down menu, choose the filegroup for this entity from the File Group field.
   • The default PRIMARY filegroup defined in SQL Server for the Aptify database is populated by default.
     
     
4. Add additional information to the Entities record as necessary.
5. Save and close the Entities record.

Anchor
Adding Additional Base Tables to Filegroups Adding Additional Base Tables to Filegroups

Adding Additional Base Tables to Filegroups

Within Aptify, an entity can have multiple base tables that can be added to different filegroups. Follow these steps to add a newly added base table to a filegroup:

1. Open a new or existing Entities record.
2. Open a new Additional Base Tables record and enter a name for the new table in the Table field.
   • See Creating Multiple Base Tables for  for more details on creating additional base tables to an entity.
     
     
3. Select a filegroup in the File Group field and click OK.
   • Note that the Text/Image File Group field is disabled since no qualifying fields with text or image data types have been added to the table as of yet.
     
     
4. Add additional tables as necessary.
5. Click Close to close the Additional Base Tables dialog and return to the Entities record.

Anchor
Adding Text and Images to Filesgroups Adding Text and Images to Filesgroups

Adding Text and Images to Filesgroups

Aptify extends filegroup management by adding the ability to specifically group large text and image fields into a specified filegroup. If the entity contains a field with the SQL Data Type of nvarchar(max), varchar(max), ntext, or text, a filegroup can be selected to manage these text and image fields.

...