3.10a db into SQL

danielm
danielm Member Posts: 19
edited 2005-02-01 in Navision Attain
Hi all, IM trying to restore a 3.10 database to sql2000,
I've run into lots of errors - mostly that SQL doesn't like the 4 digit year that navision puts in - fixed those and then backup - and restore again.

Now I've run into a "Numeric value out of range State ID: 22003"

Any idea where I can look,
Perhaps Im going about this conversion all wrong,
is there a tool/codeunit that one can use in orfer to prepare a 3.10 db
before restoring into SQL ?

Thanks

Faizel

Comments

  • kine
    kine Member Posts: 12,562
    If you read the upgrade documentation for migrating to MS SQL you can see, that there is special migration toolkit (some Navision objects) which do check of all date fields for wrong dates. Use this toolkit before you migrate your database. Warning! Checking 2GB database can take few hours!
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories