Book a Demo

Author Topic: Import DBMS Structure - Change Field Type  (Read 2179 times)

SchmellerM

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Import DBMS Structure - Change Field Type
« on: January 23, 2008, 08:33:29 am »
Hey,

I import the structure of an older SQL Server database into EA. Meanwhile we only use unicode string types (nchar, nvarchar, ntext). I want an automatic mapping (e.g. char => nchar, varchar => nvarchar ...) but the "Database Datatype Map"-Function don't work. I added a mapping from SQL Server 2000 to SQL Server 2005 with source type "char" to destination type "nchar" or "nvarchar" but it don't work. The Field is still "char" but it lost its length ...

Can anyone help me?

Thank You

Martin