This filter can be used to rename databases (schemas) and/or tables between source and targets
| Pre-configured filter name |
dbtransform
| ||
| Classname |
com.continuent.tungsten.replicator.filter.DatabaseTransformFilter
| ||
| Property prefix |
replicator.filter.dbtransform
| ||
| Stage compatibility | |||
| tpm Option compatibility | |||
| Data compatibility | ROW Events only | ||
| Parameters | |||
| Parameter | Type | Default | Description |
transformTables
|
boolean
|
false
| If set to true, forces the rename transformations to operate on tables, not databases |
from_regex1
| string | foo |
The search regular expression to use when renaming databases or
tables (group 1); corresponds to
to_regex1
|
to_regex1
| string | bar |
The replace regular expression to use when renaming databases or
tables (group 1); corresponds to
from_regex1
|
from_regex2
| string |
The search regular expression to use when renaming databases or
tables (group 2); corresponds to
to_regex2
| |
to_regex2
| string |
The replace regular expression to use when renaming databases or
tables (group 2); corresponds to
from_regex2
| |
from_regex3
| string |
The search regular expression to use when renaming databases or
tables (group 3); corresponds to
to_regex3
| |
to_regex3
| string |
The replace regular expression to use when renaming databases or
tables (group 3); corresponds to
from_regex3
| |
from_regex4
| string |
The search regular expression to use when renaming databases or
tables (group 4); corresponds to
to_regex4
| |
to_regex4
| string |
The replace regular expression to use when renaming databases or
tables (group 4); corresponds to
from_regex4
| |
The dbtransoform filter can be used to apply standard
Java Regex expressions to rename databases and/or tables between source and target.
Up to 4 from/to regex patterns can be provided. By default the transofrmation
will be applied to Database Schema names. To use the transofrm for Table Names,
specify the transformTables=true option.
The filter will only transform database or tables, not a mix of the two. For more
advanced transofrmation you may want to consider the rename filter instead
The filter only wors with ROW events. Statement based transofrmation are not supported with this filter.