Online Documentation
Transform
Prefix of target table
This option is very convenient in cases when you wish to mix newly converted data with existing tables and easily separate them.
Example: with option set to _, you would have table 'articles' convert to '_articles'.
Table name case
Here you have a way of making converted table names lowercase or uppercase.
Column name case
Here you have a way of making converted tables' columns names lowercase or uppercase. It is separated fro table case option because you will often want to make all tables lowercase or uppercase, but column names unchanged or vice versa.
Rename indexes and constraints
Some databases allow duplicate index and constraint names, some do not. By selecting this option, you force Full Convert to generate unique names for all indexes and constraints. You will lose the names you have been using in source database.
Rename reserved word identifiers
While Full Convert uses quotes while creating target databases and so is able to create tables with columns names for example ORDER, CASE etc., this can cause problems for you when using such database. This option enforces underscore character "_" suffix for such names.
Round to # places (if 0 and more)
You will typically want to use this when you want to round monetary data to two decimal places.
Convert numerics with zero decimal places to integers
Numeric fields have specified width and precision. This is true even if precision (number of decimal places) is zero. You can use this option to convert such columns to integers during conversion process automatically.
Unicode support
Full Convert automatically recognizes source data types and translates Unicode source types to equivalent Unicode target type. If you wish to force Unicode/non Unicode types only to be used, you can set that behavior here.
Character set conversion
When you have source database using one character set (often the case with older database), while your target database uses another, this is the option that will save you from tedious rewrite of the data.
Select the source character set (some engines write in table headers which character set they use, some don't), while target character set can be auto-detected from Windows, or you can select any one yourself.