Table Filters
On this page
In a migration project, you can apply table filters to control the volume of data migrated from each table. You can apply table filters when you configure the mapping rules from the relational schema model.
Table filters allow you to:
Migrate your data in logical batches.
Limit the read operations on your source database.
Create test environments before migrating your entire database.
Table Filter Types
You can apply one filter per table. Each filter can have a SQL where clause, a row limit clause, or both.
Filter Component | Description | Example | SQL Syntax |
|---|---|---|---|
SQL | Apply a SQL where clause to the tables database query. | Only the customers who have a last name of Smith. | WHERE LASTNAME = 'SMITH' |
Row limit | Apply a SQL limit clause to the tables database query. | Only migrate the top 100 rows. | ... LIMIT 100 |
Both | Apply a SQL where clause and a limit clause to the tables database query. | Only 100 rows for customers who have a last name of Smith. | WHERE LASTNAME = 'SMITH' LIMIT 100 |