Project Settings (Type Mapping) (MySQLToSQL)
The Type Mapping project settings let you set default type mappings for the SSMA project.
Type mapping is available in the Project Settings and Default Project Settings dialog boxes:
Use the Project Settings dialog box to set configuration options for the current project. To access the type mapping settings, on the Tools menu, select Project Settings, and then click Type Mapping in the left pane.
Use the Default Project Settings dialog box to set configuration options for all projects. To access the type mapping settings, on the Tools menu, select Default Project Settings, select migration project type for which settings are required to be viewed /changed from Migration Target Version drop down and then click Type Mapping in the left pane.
Options
Source Type
It is the MySQL data type, which has to be mapped to the target database data type.
Target Type
The target database data type for the specified MySQL data type.
Add
Click to add a data type to the mapping list.
Edit
Click to edit the selected data type in the mapping list.
Remove
Click to remove the selected data type mapping from the mapping list.
Reset to Default
Click to reset the type mapping list to the SSMA defaults.
Type Mappings
The following table shows the default mapping between source and target data types
| MySQL Data Type | SQL Server Data Type |
|---|---|
| bigint | bigint |
| bigint[*..255] | bigint |
| binary | binary[1] |
| binary[0..1] | binary[1] |
| binary[2..255] | binary[*] |
| bit | binary[1] |
| bit[0..8] | binary[1] |
| bit[17..24] | binary[3] |
| bit[25..32] | binary[4] |
| bit[33..40] | binary[5] |
| bit[41..48] | binary[6] |
| bit[49..56] | binary[7] |
| bit[57..64] | binary[8] |
| bit[9..16] | binary[2] |
| blob | varbinary(max) |
| blob[0..1] | varbinary[1] |
| blob[2..8000] | varbinary[*] |
| blob[8001..*] | varbinary(max) |
| bool | bit |
| boolean | bit |
| char | nchar[1] |
| char byte | binary[1] |
| char byte[0..1] | binary[1] |
| char byte[2..255] | binary[*] |
| char[0..1] | nchar[1] |
| char[2..255] | nchar[*] |
| character | nchar[1] |
| character varying[0..1] | nvarchar[1] |
| character varying[2..255] | nvarchar |
| character[0..1] | nchar[1] |
| character[2..255] | nchar[*] |
| date | date |
| datetime | datetime2[0] |
| dec | decimal |
| dec[*..65] | decimal[*][0] |
| dec[*..65][*..30] | decimal[*][*] |
| decimal | decimal |
| decimal[*..65] | decimal[*][0] |
| decimal[*..65][*..30] | decimal[*][*] |
| double | float[53] |
| double precision | float[53] |
| double precision[*..255][*..30] | numeric[*][*] |
| double[*..255][*..30] | numeric[*][*] |
| fixed | numeric |
| fixed[*..65][*..30] | numeric[*][*] |
| float | float[24] |
| float[*..255][*..30] | numeric[*][*] |
| float[*..53] | float[53] |
| int | int |
| int[*..255] | int |
| integer | int |
| integer[*..255] | int |
| longblob | varbinary(max) |
| longtext | nvarchar(max) |
| mediumblob | varbinary(max) |
| mediumint | int |
| mediumint[*..255] | int |
| mediumtext | nvarchar(max) |
| national char | nchar[1] |
| national char[0..1] | nchar[1] |
| national char[2..255] | nchar[*] |
| national character | nchar[1] |
| national character varying | nvarchar[1] |
| national character varying[0..1] | nvarchar[1] |
| national character varying[2..4000] | nvarchar[*] |
| national character varying[4001..*] | nvarchar(max) |
| national character[0..1] | nchar[1] |
| national character[2..255] | nchar[*] |
| national varchar | nvarchar[1] |
| national varchar[0..1] | nvarchar[1] |
| national varchar[2..4000] | nvarchar[*] |
| national varchar[4001..*] | nvarchar(max) |
| nchar | nchar[1] |
| nchar varchar | nvarchar[1] |
| nchar varchar[0..1] | nvarchar[1] |
| nchar varchar[2..4000] | nvarchar[*] |
| nchar varchar[4001..*] | nvarchar(max) |
| nchar[0..1] | nchar[1] |
| nchar[2..255] | nchar[*] |
| numeric | numeric |
| numeric[*..65] | numeric[*][0] |
| numeric[*..65][*..30] | numeric[*][*] |
| nvarchar | nvarchar[1] |
| nvarchar[0..1] | nvarchar[1] |
| nvarchar[2..4000] | nvarchar[*] |
| nvarchar[4001..*] | nvarchar(max) |
| real | float[53] |
| real[*..255][*..30] | numeric[*][*] |
| serial | bigint |
| smallint | smallint |
| smallint[*..255] | smallint |
| text | nvarchar(max) |
| text[0..1] | nvarchar[1] |
| text[2..4000] | nvarchar[*] |
| text[4001..*] | nvarchar(max) |
| time | time |
| timestamp | datetime |
| tinyblob | varbinary[255] |
| tinyint | smallint |
| tinyint[*..255] | smallint |
| tinytext | nvarchar[255] |
| unsigned bigint | bigint |
| unsigned bigint[*..255] | bigint |
| unsigned dec | decimal |
| unsigned dec[*..65] | decimal[*][0] |
| unsigned dec[*..65][*..30] | decimal[*][*] |
| unsigned decimal | decimal |
| unsigned decimal[*..65] | decimal[*][0] |
| unsigned decimal[*..65][*..30] | decimal[*][*] |
| unsigned double | float[53] |
| unsigned double precision | float[53] |
| unsigned double precision[*..255][*..30] | numeric[*][*] |
| unsigned double[*..255][*..30] | numeric[*][*] |
| unsigned fixed | numeric |
| unsigned fixed[*..65][*..30] | numeric[*][*] |
| unsigned float | float[24] |
| unsigned float[*..255][*..30] | numeric[*][*] |
| unsigned float[*..53] | float[53] |
| unsigned int | bigint |
| unsigned int[*..255] | bigint |
| unsigned integer | bigint |
| unsigned integer[*..255] | bigint |
| unsigned mediumint | int |
| unsigned mediumint[*..255] | int |
| unsigned numeric | numeric |
| unsigned numeric[*..65] | numeric[*][0] |
| unsigned numeric[*..65][*..30] | numeric[*][*] |
| unsigned real | float[53] |
| unsigned real[*..255[[*..30] | numeric[*][*] |
| unsigned smallint | int |
| unsigned smallint[*..255] | int |
| unsigned tinyint | tinyint |
| unsigned tinyint[*..255] | tinyint |
| varbinary[0..1] | varbinary[1] |
| varbinary[2..8000] | varbinary[*] |
| varbinary[8001..*] | varbinary(max) |
| varchar[0..1] | nvarchar[1] |
| varchar[2..4000] | nvarchar[*] |
| varchar[4001..*] | nvarchar(max) |
| year | smallint |
| year[2..2] | smallint |
| year[4..4] | smallint |
Add
Click to add a data type to the mapping list.
Edit
Click to edit a data type in the mapping list.
Remove
Click to remove the selected data type mapping from the mapping list.
Reset to Default
Click to reset all data type mappings to the SSMA defaults.