Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

DDL datatype mapping

JO3Y
2007-09-12
2013-05-28
  • JO3Y
    JO3Y
    2007-09-12

    Temporal:Date maps to SQL server as such:

    CREATE TABLE SBSSM.OrderHistory
    (
        "Date" BIGINT ,
        DeltaDeposit DECIMAL, 4) NOT NULL,
        DepositTender_TenderEntry_ID BIGINT NOT NULL,
        Order_Order_ID BIGINT NOT NULL,
        CONSTRAINT IntrnlUnqnssCnstrnt117 PRIMARY KEY(DeltaDeposit, DepositTender_TenderEntry_ID)
    )

    1. should not be BIGINT

    2.also note money type scale 4 maps to DECIMAL, 4) <-- invalid TSQL