Migrating To Attain 3.60 Using SQL Server

sc00by
sc00by Member Posts: 43
edited 2003-02-11 in Navision Attain
Hi,

I'm new to the Navision world and am having some troubles in loading my legacy data (extracted in flat files) into Navision (SQL Server 2000). The problem seems to be where Navision doesn't like NULL values - thus my BCP process fails on the NULL constraints.

I suppose I can get around this by using dataports, however, we have 20 million rows to load into the interaction log and this may take some time!

Any ideas or tips would be greatly appreciated.

Rob Lord.

Comments

  • M@rtin
    M@rtin Member Posts: 9
    You try OFF Contsraint on column.

    Alter Table Test
    NOCHECK
    Contraint CN_TestConstraint

    then you try insert data. If will good then ON Contraint
    Alter Table Test
    CHECK
    Contraint CN_TestConstraint

    Contraint "Primary key and Unique" cannot be off.
    Stored procedure which help you: sp_helpconstraint table_name

    I cannot tell if help you :?:

    Martin

Categories