Project Settings (Type Mapping) (AccessToSQL)
The Type Mapping project settings let you set default type mappings for the SSMA project. You can also specify type mappings for individual database objects. For more information, see Mapping Source and Target Data Types.
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
The Access data type to map.
Target Type
The target SQL Server or SQL Azure data type for the specified Access data type.
The following table shows the default mapping between source and target data types.
| Access Data Type | SQL Server Data Type |
|---|---|
| binary[*..*] | varbinary[*] |
| boolean | bit |
| byte | tinyint |
| currency | money |
| date | datetime |
| decimal | float |
| double | float |
| guid | uniqueidentifier |
| integer | smallint |
| long | int |
| longbinary | varbinary(max) |
| memo | nvarchar(max) |
| memo - for Access 97 | varchar(max) |
| single | real |
| text[*..*] | nvarchar[*] |
| text[*..*] - for Access 97 | varchar[*] |
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.
See Also
Mapping Source and Target Data Types
User Interface Reference(Access)