3.10a db into SQL

danielm

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

kine

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!