![]() ![]() To remove a data type mapping, do the following: In the Type Mapping List dialog box, under Source type, select the MySQL data type to map. To edit a type mapping, do the following: If required, enter the new precision and scale in the Replace With box, and then click OK. Some types require a target data type precision and scale. If required, enter the new data length in the Replace With box, and then click OK. Some types require a target data type length. Under Target type, select the target SQL Server or SQL Azure data type. This lets you customize the data mapping for smaller and larger values of the same data type. If the type requires a length, specify the minimum and maximum data lengths for the mapping by selecting the From and To check boxes, and then entering the values. ![]() In the New Type Mapping dialog box, under Source type, select the MySQL data type to map. ![]() In the MySQL Metadata Explorer, select the folder or object to customize. To customize data type mappings at the database or table level, select the database or table in the MySQL Metadata Explorer. The type mapping chart and buttons appear in the right pane. On the Tools menu, select Project Settings. To customize data type mapping for the whole project, open the Project Settings dialog box. The following procedures show how to map data types at the project, database, or database object level: The background of a type mapping is yellow for any inherited type mapping, and white for any mapping that is specified at the current level. When you view the Type Mapping tab in SSMA, the background is color-coded to show which type mappings are inherited. For example, if you map smallint to int at the project level, all objects in the project will use this mapping unless you customize the mapping at the object or category level. Settings are inherited from the higher level unless they are overridden at a lower level. You can customize type mappings at the project level, object category level (such as all stored procedures), or object level. For the list of default mappings, see Project Settings (Type Mapping) (MySQLToSQL). SSMA has a default set of data type mappings. You can accept the default data type mappings, or you can customize the mappings as shown in the following procedures. When you convert MySQL database objects to SQL Server or SQL Azure objects, you must specify how to map data types from MySQL to SQL Server or SQL Azure. MySQL database types differ from SQL Server or Azure SQL Database types. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |