Schema Sync

ta5ta5 Member Posts: 1,164
Hi experts
Just a question: I have noticed that schema sync does take significantly longer in big databases. Do you experience the same? Does sql server need to copy the data into temp tables or something like that?
Thanks in advance, kind regards

Best Answer


  • ta5ta5 Member Posts: 1,164
    Thanks Slawek, sounds plausible.

    Anyone else?
  • kenniekennie Member Posts: 34
    Regarding "Schema sync may also take long time if you add a field to a large table, or add or modify an index on it.", we made optimizations in NAV2018 that utilize ONLINE operations on SQL Server (if you run on an edition that supports that). Some sync operations in NAV2018 also do ALTER TABLE renames instead of CREATE/COPY DATA/DROP.
  • ta5ta5 Member Posts: 1,164
    Hi Kennie
    Thx for the details!
Sign In or Register to comment.