NAV to SQL conversion date problem

pmusu

Hi,

We are currently in the process of converting from NAV database to NAV SQL.
We are encountering problems with the dates. E.g. Posting Date is 01/01/0009.

The question is the following:
Is there a way to loop all the tables in Navision, check all date fields in that table, and check entries of the table to see if dates are less than a certain date e.g. 31/12/1980.

Thanks in advance.

JedrzejT

You have tool to check fields for wrong values in migrate.fob
I dont remeber exactly , but i think this finds date with very low year.
If not you can modify this tool a little for your needs

pmusu

JedrzejT wrote:

You have tool to check fields for wrong values in migrate.fob
I dont remeber exactly , but i think this finds date with very low year.
If not you can modify this tool a little for your needs

Thanks for the response.
Could you please tell me where this file is located, or from where I could download this FOB.

Thanks

JedrzejT

Go to partnersource and search for "Microsoft SQL Server Migration Tool for Microsoft Dynamics NAV"

David_Singleton

In all honesty, if you don;t know this then you should not be doing this conversion. contact your partner and get help from them.

kine

David Singleton wrote:

In all honesty, if you don;t know this then you should not be doing this conversion. contact your partner and get help from them.

The SQL migration is work for your partner, becuase even if you will have the tool for checking the dates, you will not be able to change the date in posted entries.