Native -> SQL Server (Date check)

sbrinkkoetter
sbrinkkoetter Member Posts: 3
edited 2013-02-04 in SQL General
Hi,

could anybod please help me with the date check in the native database? Is there a routine to find out, in which tables incorrect date fields exist? The restore of a native backup failed at 55%. So I have to correct the date an make a new backup to restore it in thesql server.

Thank you very much for your help!

Greetings
Stefan

Answers

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Use Migrate.fob in the folder UpgradeToolKit\SQL Migration\ of the NAV product DVD. This contains objects to find incorrect dates, which can then be corrected.

    Or use these downloads:
    Field Check v3
    Report to convert illegal date-values v2
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • sbrinkkoetter
    sbrinkkoetter Member Posts: 3
    Thank you !!!

    It was a great success with these tools. My sql database is now online...

    Greetings
    Stefan

Categories