Date value Problem

Martin_Förster

hello,

i try to upgrade NAV 4.03 to SQL 2005.

It's my first time that i try that so maybe someone can help me.

After Creating a new Database on SQL 2005 i want to restore a exiting NAvision Database.

I get the Error: the customer table contains a field with a date value that cannot be used with Sql 2005:

Rec. No. xyxyx
Field: birthday='16.03.1679'

What can i do? Is there an Problem with the Year '1679'??

Thx for Help.

stryk

Hi!

Before migrating from "native" NAV to SQL you have to prepare the database before the backup. The "Upgrade Toolkit" includes several objects (migrate.fob) to do this task.

I recommend to check this out:http://www.mibuso.com/dlinfo.asp?FileID=917

Regards,
Jörg

stryk

... uh, P.S.: the error occurs, because SQL Server does not support dates before 01.01.1753 ...

tinoruijs

Martin Förster wrote:

Rec. No. xyxyx
Field: birthday='16.03.1679'

What can i do? Is there an Problem with the Year '1679'??

Thx for Help.

You could not import the old employees with birthdates before 01.01.1753!!

Martin_Förster

Thank you very much.

Regards from Zürich

DenSter

Martin Förster wrote:

Field: birthday='16.03.1679'

How's that for equal opportunity employment huh Age not a problem.

Is that for a geneology solution, or something to do with some sort of archive? A cemetary perhaps?

garak

Martin Förster? An old employee of FKK in Leipsch?

Martin_Förster

Ja so ist es :-)

wen hab ich denn dort?

Grüsse aus Zürich