Schema Sync

ta5

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

Slawek_Guzek

It depends.

If you have an upgrade codeunit, and in it you have a function defining synchronisation rules, and in it you have a line saying that some large table shoud be copied to another temp table then yes, NST will make a copy of the table as told.

Schema sync may also take long time if you add a field to a large table, or add or modify an index on it.

Slawek

Slawek_Guzek

It depends.

If you have an upgrade codeunit, and in it you have a function defining synchronisation rules, and in it you have a line saying that some large table shoud be copied to another temp table then yes, NST will make a copy of the table as told.

Schema sync may also take long time if you add a field to a large table, or add or modify an index on it.

Slawek

ta5

Thanks Slawek, sounds plausible.

Anyone else?

kennie

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.

ta5

Hi Kennie
Thx for the details!
Thomas