Editing data type mappings in the AWS Schema Conversion Tool
You can filter or delete existing mapping rules, and add a new mapping rule in your AWS Schema Conversion Tool (AWS SCT) project.
When you create a mapping rule for the whole source database, AWS SCT creates one mapping rule for each source database schema. For projects that involve dozens of schemas or even databases, it may be hard to understand, which target is used for a certain schema. To quickly find a mapping rule for your schema, use one or several of the following filter options in AWS SCT.
To filter mapping rules
-
On the View menu, choose Mapping view.
-
For Source servers, choose the source database.
The filter default is All, which means that AWS SCT displays mapping rules for all source databases.
-
For Source schema, enter the source schema name. Use the percent (
%) as a wildcard to replace any number of any symbols in the schema name.The filter default is the % wildcard, which means that AWS SCT displays mapping rules for all source database schema names.
-
For Has migration rules, choose Yes to display mapping rules for which the data migration rules are created. Choose No to display mapping rules which don't have data migration rules. For more information, see Creating data migration rules in AWS SCT.
The filter default is All, which means that AWS SCT displays all mapping rules.
-
For Target servers, choose the target database.
The filter default is All, which means that AWS SCT displays mapping rules for all target databases.
With your project open, use the following procedure to delete a mapping rule. For more information on adding mapping rules, see Mapping new data types in the AWS Schema Conversion Tool.
To delete mapping rules
-
On the View menu, choose Mapping view.
-
For Server mappings, choose the mapping rules to delete.
-
Choose Delete selected mappings.
AWS SCT deletes the selected mapping rules.
