Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The entity filter is a collection of conditions that allows you to include or exclude database objects. Conditions are organized into units called groups. A single group contains conditions combined with the same operator: AND/OR. The groups themselves can be are combined with an operator that may can be the same as or different from the conditions' operator.

Image RemovedImage Added

There is no limit to the number of groups that a filter can have or the number of conditions contained in a single group. In order to To keep the filter simple, we recommend that you place all conditions that can be combined with a common operator in the same group. Create additional groups only if you need conditions that require a different operatoroperators.

The following filter, for example, defines two conditions combined with the AND operator. It requires only one group.

  • name does not start with "v_temp" and
  • name does not contain "temp"

The following filter contains two conditions combined with the AND operator and requires only one group:

  • name does not start with "v_temp" and
  • name does not contain "temp"

The following table filter, on the other hand, contains conditions that requires require different operators , therefore and two groups are needed.:

Group 1:

    • name starts with "emp" or
    • name ends with "emp"

...

Info

An entity filter, similar to other comparison settings, is saved in the comparison session and it is applied automatically when you launch the session.

Excerpt

Total compare from data to schema with IDERA Comparison Toolset. Learn more > >

Save

...

Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/it-database-management-tools
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse