When you click on database itself "Database options" are displayed in the right panel.
![]()
![]()
There is an option to "overwrite existing database". If a database being copied already exists, this option
specifies whether it will be overwritten (this will cause all data in it to be lost).There is an option to Use lowercase. If checked all the names of the database elements will be converted in lower case. For example: “TableName” will be converted into “tablename”.
NOTE: This option is not available when converting to MySQL.
There are some special symbols which are required not to be used as they are the symbols reserved for MySQL internal purposes. Here you can replace all garbage symbols in the database. Click at the database name in the left panel. Database Options appear in the right panel where you enter all special symbols, for example "'"\:/*<> -+" in the field "Garbage symbols to replace/remove".
After pressing "Replace all" button you will get a message where you will be offered to choose a correct name. You can confirm the offered name by clicking on "OK" button. If you click "Apply All" all the unwanted symbols will be automatically replaced with the symbol entered in the "Replace with" field. In case you click "Cancel" the name will stay untouched.
![]()
Finally the database objects that were previously marked red won't cause any problems.
