Project Settings (Type Mapping) (SybaseToSQL)
The Type Mapping page of the Project Settings dialog box contains settings that customize how SSMA converts Sybase Adaptive Server Enterprise (ASE) data types into SQL Server data types.
The Type Mapping page is available in the Project Settings and Default Project Settings dialog boxes.
To specify the type mapping settings for all future SSMA projects, on the Tools menu, select Default Project Settings, select migration project type for which settings are required to be viewed or changed from Migration Target Version drop down and then select Type Mapping at the bottom of the left pane.
To specify settings for the current project, on the Tools menu, select Project Settings, and then select Type Mapping at the bottom of the left pane.
Options
Source Type
The mapped ASE data type.
Target Type
The target SQL Server data type for the specified ASE data type.
See the table in the following section for the default SSMA for Sybase type mapping.
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.
Default Type Mapping
The following table contains the default type mapping between ASE and SQL Server data types.
| ASE Data Type | SQL Server Data Type |
|---|---|
| bigint | bigint |
| binary | binary |
| binary[*..8000] | binary[*] |
| binary[8001..*] | varbinary(max) |
| bit | bit |
| char | char |
| char varying | varchar |
| char varying[*..8000] | varchar[*] |
| char varying[8001..*] | varchar(max) |
| char[*..8000] | char[*] |
| char[8001..*;] | varchar(max) |
| character | char |
| character varying | varchar |
| character varying[*..8000] | varchar[*] |
| character varying[8001..*] | varchar(max) |
| character[*..8000] | char[*] |
| character[8001..*] | varchar(max) |
| date | date |
| datetime | datetime2[3] |
| dec | decimal |
| dec[*..*] | decimal[*] |
| dec[*..*][*..*] | decimal[*][*] |
| decimal | decimal |
| decimal[*..*] | decimal[*] |
| decimal[*..*][*..*] | decimal[*][*] |
| double precision | float[53] |
| float | float[53] |
| float[*..15] | float[24] |
| float[16..*] | float[53] |
| image | image |
| int | int |
| integer | int |
| longsysname | nvarchar[255] |
| money | money |
| national char | nchar |
| national char[*..4000] | nchar[*] |
| national char varying | nvarchar |
| national char varying[*..4000] | nvarchar[*] |
| national char varying[4001..*] | nvarchar(max) |
| national char[4001..*] | nvarchar(max) |
| national character | nchar |
| national character[*..4000] | nchar[*] |
| national character[4001..*] | nvarchar(max) |
| national character varying | nvarchar |
| national character varying[*..4000] | nvarchar[*] |
| national character varying[4001..*] | nvarchar(max) |
| national varchar | nvarchar |
| national varchar[*..4000] | nvarchar[*] |
| national varchar[4001..*] | nvarchar(max) |
| nchar | nchar |
| nchar varying | nvarchar |
| nchar varying[*..4000] | nvarchar[*] |
| nchar varying[4001..*] | nvarchar(max) |
| nchar[*..4000] | nchar[*] |
| nchar[4001..*] | nvarchar(max) |
| numeric | numeric |
| numeric[*..*] | numeric[*] |
| numeric[*..*][*..*] | numeric[*][*] |
| nvarchar | nvarchar |
| nvarchar[*..4000] | nvarchar[*] |
| nvarchar[4001..*] | nvarchar(max) |
| real | float[24] |
| smalldatetime | smalldatetime |
| smallint | smallint |
| smallmoney | smallmoney |
| sysname | nvarchar[128] |
| sysname[*..*] | nvarchar[255] |
| text | text |
| time | time[3] |
| timestamp | rowversion |
| tinyint | tinyint |
| unichar | nchar |
| unichar varying | nvarchar |
| unichar varying[*..4000] | nvarchar[*] |
| unichar varying[4001..*] | nvarchar(max) |
| unichar[*..4000] | nchar[*] |
| unichar[4001..*] | nvarchar(max) |
| unitext | nvarchar(max) |
| univarchar | nvarchar |
| univarchar[*..4000] | nvarchar[*] |
| univarchar[4001..*] | nvarchar(max) |
| unsigned bigint | numeric[20][0] |
| unsigned int | bigint |
| unsigned smallint | int |
| unsigned tinyint | tinyint |
| varbinary | varbinary |
| varbinary[*..8000] | varbinary[*] |
| varbinary[8001..*] | varbinary(max) |
| varchar | varchar |
| varchar[*..8000] | varchar[*] |
| varchar[8001..*] | varchar(max) |