Skip to content

Latest commit

 

History

History
43 lines (31 loc) · 2.26 KB

edit-type-mapping-accesstosql.md

File metadata and controls

43 lines (31 loc) · 2.26 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Edit Type Mapping (AccessToSQL)
Edit Type Mapping (AccessToSQL)
cpichuka
cpichuka
01/19/2017
sql
ssma
conceptual
sql-migration-content

Edit Type Mapping (AccessToSQL)

The Edit Type Mapping dialog box lets you specify how types are mapped between the source and destination database objects.

You can access this dialog box in several places:

  • When you select a source database or database object, the Type Mapping tab appears to the right of the metadata explorer. Click Add to add a new type mapping, or click Edit to change an existing type mapping.

  • On the Tools menu, select Project Settings or Default Project Settings. In the resulting dialog box, select Type Mapping. Click Add to add a new type mapping, or click Edit to change an existing type mapping.

Table-specific type mappings override database and project type mappings. Database-specific mappings override project mappings.

Options

Source type
Select the source data type to map to a [!INCLUDEssNoVersion] data type.

If the data type is of variable length, the following fields will appear under Source type:

From
Specify the minimum length for this mapping. For example, for the text data type, you can enter 10 to specify that this mapping is for a range starting at text(10).

To
Specify the maximum length for this mapping. For example, for the text data type, you can enter 20 to specify that this mapping is for a range ending at text(20).

Target type
Select the [!INCLUDEssNoVersion] data type to which the source data type is mapped. When SSMA creates the table or stored procedure in [!INCLUDEssNoVersion], the source data type will change to this data type.

If the data type is of variable length, the following field will appear under Target type:

Replace with
Specify the target length for this mapping. For example, for the nvarchar data type, you can enter 20 to specify that the specified source data type should be mapped to nvarchar(20).