Author Topic: Customized database datatype mapping not working  (Read 511 times)

Arquesoft

  • EA User
  • **
  • Posts: 68
  • Karma: +0/-0
    • View Profile
Customized database datatype mapping not working
« on: May 11, 2016, 01:42:13 am »
The following bug was tested on both EA10 and EA12.1.

After customizing the Database datatypes mapping (PROJECT/Settings/Database datatypes/Datatype Map) from MySQL to SQLServer 2012, I want to convert MySQL "datetime" into SQLServer "datetime2" and MySQL "text" into SQLserver "varchar(max)". I double-checked the mapping is stored (because the user interface is very weird) and execute the transformation in the package containing the tables via Right Click/Code Engineering/Reset DBMS Options and choosing convert DBMS Type from MySQL to SQLServer 2012.

The result: the mappings for "datetime" and "text" were executed as the default mapping, not as my customized mapping.

Am I doing something wrong? is any step missing?