From:       To:      

Home > Documentation > SQL Server to MySQL

Edit Table

SQL Server to MySQL converter provides this feature in order to rename table or customize name, types and other attributes of every column as well as excluding certain columns from migration. The application maps types in the most intelligent way. However, sometimes it may be required to implement user-defined types mapping.

To customize migration of MySQL table, double-click on the corresponding selected item on "Select Tables" wizard page. In the appeared dialog box specify table name, type and default value for any columns using "Field info" group of controls. Also it is possible to exclude columns from conversion result by unchecking the corresponding checkbox.

Listview on the left of "Edit Table" dialog window contains column attributes for the original MySQL table, new types and attributes are displayed in "Field info" section when the corresponding item is highlighted in the listview.

NOTE: inaccurate modification of table structure may break the database integrity (for example, loosing indexes or foreign keys).

Have any questions? Contact us