项目设置（类型映射）(MySQLToSQL)
“类型映射”项目设置允许为 SSMA 项目设置默认类型映射。
“项目设置”和“默认项目设置”对话框中都提供了类型映射。
使用“项目设置”对话框设置当前项目的配置选项。 要访问类型映射设置，请在“工具”菜单上选择“项目设置”，然后单击左窗格中的“类型映射”。
使用“默认项目设置”对话框为所有项目设置配置选项。 要访问类型映射设置，请在“工具”菜单上选择“默认项目设置”，从“迁移目标版本”下拉列表中选择需要为其查看/更改设置的迁移项目类型，然后单击左窗格中的“类型映射”。
选项
源类型
它是 MySQL 数据类型，必须映射到目标数据库数据类型。
目标类型
此即指定 MySQL 数据类型的目标数据库数据类型。
添加
单击此项可向映射列表添加数据类型。
编辑
单击此项可编辑映射列表中的所选数据类型。
删除
单击此项可从映射列表中删除所选数据类型映射。
重置为默认值
单击此项可将类型映射列表重置为 SSMA 默认值。
类型映射
下表显示了源数据类型和目标数据类型之间的默认映射
| MySQL 数据类型 | SQL Server 数据类型 |
|---|---|
| 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) |
| 布尔型 | 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[*] |
| 角色 | 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[*][*] |
| 双精度 | float[53] |
| 双精度 | float[53] |
| double precision[*..255][*..30] | numeric[*][*] |
| double[*..255][*..30] | numeric[*][*] |
| fixed | 数字 |
| fixed[*..65][*..30] | numeric[*][*] |
| float | float[24] |
| float[*..255][*..30] | numeric[*][*] |
| float[*..53] | float[53] |
| int | int |
| int[*..255] | int |
| integer | int |
| integer[*..255] | 整数 |
| longblob | varbinary(max) |
| longtext | nvarchar(max) |
| mediumblob | varbinary(max) |
| mediumint | 整数 |
| 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 | 十进制 |
| 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[*][*] |
| 无符号浮点 | float[24] |
| unsigned float[*..255][*..30] | numeric[*][*] |
| unsigned float[*..53] | float[53] |
| unsigned int | bigint |
| unsigned int[*..255] | bigint |
| 无符号整数 | bigint |
| unsigned integer[*..255] | bigint |
| 无符号 mediumint | int |
| unsigned mediumint[*..255] | 整数 |
| unsigned 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 |
添加
单击此项可向映射列表添加数据类型。
编辑
单击此项可编辑映射列表中的数据类型。
删除
单击此项可从映射列表中删除所选数据类型映射。
重置为默认值
单击此项可将所有数据类型映射重置为 SSMA 默认值。