After the database objects are created on the target database server the MySQL Migration Toolkit is ready to move the server data to the target server. You have the option of either inserting the data directly on the target server or to create a script file of the INSERT statements for later execution:

Figure 9.21. The Data Mapping Options Screen

Select both options to move the data and preserve a backup copy of the INSERT statements for later use.

You can access additional options by clicking the Details button. If you do not wish to move BLOB data to the target server, check the box next to the Exclude BLOB values option. The BLOB data will not be moved to the target server and will not be written to the script file. If you do not wish to move BLOB data to the target server, but wish to have the BLOB data written to the script file, also check the box next to the Write BLOBs to Insert Script option.

If you wish to limit the number of rows transferred to the target server, check the box next to the Maximum Numbers of Rows to Transfer for a Table option and enter the desired number of rows. This option can be useful when generating test data.