Our tools can handle data types conversion automatically and safely before migration keeping correct data at destination. Software throws a warning message, if there is a potential problems with trimming of data.
Global Data types mapping may be configured. The whole database will be affected.
Or Optionally you can map data types for certain fields manually.
This article describes the correct types mapping between MySQL and MS SQL Servers to find the most suitable equivalents between Source and Destination.