C.5 Customizing Data Types

  1. On the Microsoft SQL server, launch the Microsoft SQL Server Migration Assistant for MySQL.

  2. Click Tools > Project Settings.

    The Project Settings dialog box is displayed.

  3. Click Type Mapping, select bigint(*..255) in the Source Type column, then click Edit.

    The Edit Type Mapping dialog box is displayed.

  4. In the Target Type drop-down list, select Numeric (Precision, Scale).

  5. In the Precision section, specify 19.

  6. In the Scale section, specify 0, then click OK.

  7. Select datetime in the Source Type column, then click Edit.

    The Edit Type Mapping dialog box is displayed.

  8. In the Target Type drop-down list, select datetime, then click OK.

  9. Click Apply > OK.

  10. Continue with Section C.6, Migrating the Database Schema.