Bad Dates during upgrade to SQL Nav 4.0

twdavistwdavis Member Posts: 79
edited 2007-06-02 in SQL General
I am upgrading a client to SQL Nav 4.0. their data appears to contain numerous "bad dates" that SQL does not like. Does anyone know of a utility that I can obtain that will search all date fields in all Navision tables and list them for corrective action?

Comments

  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    There exists a SQL Migration Tool which can find incorrect dates. More info in this thread: How to import a navision database into SQL Server?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • ara3nara3n Member Posts: 9,256
    upgrade toolkit has migration.fob file that has the code to fix the dates.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • krikikriki Member, Moderator Posts: 9,115
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.