9 Replies Latest reply: Nov 25, 2013 4:35 AM by Tony Rose RSS

    Import MS SQL DB - Merge problem with Decimal and Default value

    Mrtvola

      Database table has column type Decimal(19,2), Data Modeler has same column Decimal(19,2) (Precision:19, Scale: 2) but when I select Import -> Data Dictionary -> ... ->  Merge so, Data Modeler says me, these columns are not same, Modeler says, database column is Decimal(19) and Data Modeler column is Decimal(19,2). Where is problem?

       

       

      Similar problem is with default value. I have column type Bit with default value "0" (DB and Data Modeler has same column) but when I select Import -> Data Dictionary -> ... ->  Merge so, Data Modeler says me, these columns are not same, Modeler says, database column doesn't have default value.

       

      Help me!

      Thx.

       

      PS: It is DB MS SQL 2008