Docs Menu
Docs Home
/
Relational Migrator
/
Table Filters

Apply Table Filters

On this page

  • Before you Begin
  • Steps
  • Learn More

You can use table filters to migrate specific subsets of your table data. Table filters allow you to apply SQL where and row limit clauses when pulling data from your table.

Before you Begin

Table filters are applied while you are creating mapping rules. See Create Rules From Relational for more details.

You can apply one filter per table. Each filter can have a SQL where clause, a row limit clause, or both.

Steps

1

Apply a table filter

  1. From the Schema model pane, click the table that you want to apply a filter to.

  2. On the Filter on section in the edit mapping rule pane, click + Add.

  3. Under the SQL query header, enter a SQL where criteria. The SQL you specify must be ANSI SQL compliant with your relational database.The following are examples of SQL where clauses used to apply SQL query table filters:

    • LASTNAME LIKE '%SMITH%'

    • LASTNAME = 'SMITH'

    • LASTNAME IN('SMITH')

    • LASTNAME IN(SELECT LASTNAME FROM ASIA_CUSTOMERS WHERE ID < 100000)

2

(Optional) Add a row limit

Under the Row limit header, click the Limit number of rows radio button and enter a value. This applies a limit clause at the end of your SQL query.

3

Save your table filter

Click Save and close.

Note

After you save your filter, the Schema model pane displays a icon for any tables containing a filter under the Relational header.

Learn More

Mapping Rules

Back

Table Filters

Next

Edit