Adding and Editing Groups

Adding and editing groups are both accomplished in the Group Properties dialog.  To access the Group Properties dialog, go to the Groups Tab and click the Add Group button to add a new group, or click the edit button on the group to be edited.

 

When Adding a new group, the Group Properties fields will be empty:

GroupPropertiesNew.bmp

 

When Editing an existing group, the Group Properties fields will contain the current values for the group:

GroupPropertiesEdit.bmp

The Group Properties Dialog contains the following fields:

  • Group Name
    This is the name the group will be known as.  Spaces and non printable characters are not allowed as part of the name.
     

  • Only show tables not already grouped checkbox
    Click the Only show tables not already grouped check box to show ungrouped tables. Displaying and viewing ungrouped tables may help to avoid accidentally scheduling resynchronization of identical tables or transformations.
     

  • Only track changes checkbox
    Checking this checkbox will filter the list of available tables to only show transformations.  This includes Change Data Capture Transformations.  
    Note: When unchecked, CDC Transformations will not be displayed in the Available Tables list.
     

  • Available Tables listbox
    This is the list of tables and transformations that are available to be added to the group.  There is a Search field at the top of the list that will filter the list based on what is put in the field.  For example, entering "employees" in the search field will filter the list to only show entries that contain the string "employees".
     

  • Selected Tables listbox
    This is the list of tables and transformations that are in the group.
     

  • Right and Left Arrow buttons
    These arrow buttons move items to and from the Available Tables listbox and the Selected Tables listbox.  To move an item, check the checkbox next to the item and then click the arrow button for the direction the item is to be moved.  Items can also be moved by dragging and dropping from one listbox to the other.  Multiple selections can be made by clicking individual check boxes or by selecting a range using the shift key.
     

  • Target Override
    Optionally, you may override the default target database by selecting Target Override.
    GroupPropertiesTargetOverride.bmp

    Selecting a new target from the Override Target Database dropdown. Enter the target file name directory, if applicable. (This function is only available for databases which use target file names.) To change the file name extension, for example, from .dat to .bak, enter the new file name extension in the File Extension text box