restore DB 4.02 Date Format

flint

Hi everybody,

I'm triying to restore a DB 4.0SP2.I got the message Table archive contain a field with a date value icompatible with SQL Server Date format.
Actually there's a row in this table with the value of a date field is "31/12/0007"

How could i work around this probleme ?

Thanks

kine

You need to follow Migration toolkit. It means you need to run the Migration toolkit over the Native DB, which will check for all dates which are incompatible with MS SQL and will correct them. After that you can create the backup and restore it on MS SQL. Look into Upgrade Toolkit for NAV, the Migration toolkit is part of the package.