Datatype error on Data migration from Native database to SQL server Database in NAV 2009

Business Central/NAV Technical Forum
1

Hello All,

I am working on NAV upgrade from NAV 2009 to NAV 2009 SP1 for that we followed following steps

1.Opened native database file(.fdb) sent by client using SuperUser UserID and Password.

2.Backup of database file in .fbk.

3.Create new database in NAV classic with sql server

4.Restore backup database file on newly created databse.

but for migrating database while restoring backup on new database in sql server, system is showing following error.

The G/L Entry table contains a field with a date value that cannot be used with SQL Server:

Record: Entry No.=‘54643’
Field: Document Date=‘12/17/1707’

Can anybody please tell me how to resolve this error for successful data migration in sql server.

Regards,

2

Hi Asim,

SQL Server doesn’t support dates prior to 1753, that is why you are getting this error.

Solution: In the upgrade toolkit you will find some objects for Migration purpose, which will check the dates prior to 1753 and you need to change those values.