Schema Sync

ta5ta5 Posts: 1,150Member
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
Thomas

Best Answer

Answers

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

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