restore DB 4.02 Date Format

flintflint Member Posts: 44
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 ?



  • kinekine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.