Documentation

Table of Contents:


    Filtering imported objects

    Applies to: 5.x, Article available also for: 6.x
    You are looking at documentation for an older release.
    Switch to the documentation for Dataedo 7.x (current).

    By default Dataedo imports all objects from documented database. However, you may configure which objects you want to import. You may define it based on:

    • Object type
    • Schema name pattern
    • Object name pattern

    To define filter enter advanced options checking Advanced settings checkbox and click Connect button.

    On next screen, advanced settings form, select Define filter option.

    This will enable filter rules editor.

    There are two sets of rules - Include rules and Exclude rules. To add a rule click Add include/exclude rule link underneath. To remove any specific rule click Remove rule next to it.

    Include rules

    Include rules define your set of objects - each rule adds objects to your set of objects to import.

    There is logical OR operator between include rules.

    Exclude rules

    Each excludes rule subtracts objects from to your set of imported objects defined by include rules.

    There is logical AND operator between exclude rules and a NOT operator before each rule.

    Exclude rules are more important than include rules.

    Patterns

    • 'temp' means all objects which name is 'temp'
    • 'temp%' means all objects that name starts with string 'temp'
    • '%temp' means all objects that name ends with string 'temp'
    • '%temp%' means all objects that have string 'temp' in their name

    Examples

    Example 1: Tables only

    Below example imports tables from all schemas.

    Example 2: Specific schema only

    Below example imports all objects (tables, views, stored procedures, views) from 'hr' schema.

    Example 3: Specific prefix

    Below example imports all objects that names begin with 'cust' prefix.

    Example 4: Exclude stored procedures and functions

    Below example imports all objects but excludes any stored procedures and functions.

    Example 5: Advanced

    Below example imports tables and views plus functions from 'hr' schema, but excludes any object from 'admin' schema and any object which name ends with 'temp'.

    Found issue with this article? Comment below
    0
    There are no comments. Click here to write the first comment.