Schema Sync

ta5ta5 SwitzerlandPosts: 1,164Member
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 SwitzerlandPosts: 1,164Member
    Thanks Slawek, sounds plausible.

    Anyone else?
  • kenniekennie Posts: 34Member
    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 SwitzerlandPosts: 1,164Member
    Hi Kennie
    Thx for the details!
Sign In or Register to comment.