Import Navison DB on SQL2000 Server

heynem

Hi everbody,

we want to import a Backup from a Navision Database into a SQL2000
Server. Everthing works fine, bute when we start the Program "Import
Backup" the SQL Server do not accept wrong dates i.e. the year 2065.

The problem is the procedure stops :? :?

Is there any chance to tell the SQL server to ignore the wrong dates
in the different tables ???

I hope I have explained the situation understandable

Best regards to everebody
Michael

orossi

The problem is the following:
SQL doesn't accept any date value. It has its limits. Navision database server can handle any date from 1/1/0000 to 31/12/9999 (I think).
So you have to run a special codeunit found in the Navision CD. You have to import the Migrate.fob file, found in the NFUPGTK\ folder. In the same folder you have a pdf document for the entire Upgrade Toolkit. You have to read the chapter "Migrating to the Microsoft SQL Server Option for Navision"

I Hope this may be helpful.

Regards.
Osvaldo.

Captain_DX4

I did a migration just last weekend. I swear I saw a transaction dated year 0000 for something marked "birthday present". (Kidding *lol*)

kine

it is common, sometime users enter data like '0102000' instead '010200' (01/02/2000) and the wrong date is there... 8)