Making changes to a table that is included in SQL Replication

afarr
afarr Member Posts: 287
in NAV Three Tier
We have a NAV 2016 database, on SQL 2016 Enterprise, and we may be adding a (normal) field to a table.
The table is included in (transactional) SQL Replication.
We know that there are SQL commands to make changes to replicated tables, but can these be used with Dynamics NAV?
https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/make-schema-changes-on-publication-databases?view=sql-server-ver15


Or do we need to remove the table from SQL Replication, make our changes in Nav, and then add the table to SQL Replication?
I found several posts from 2005 – 2011 saying that that is the only way to proceed. I just want to check if that is still correct for Nav 2016 and SQL 2016.
https://dynamicsuser.net/nav/f/technical/29420/can-t-import-changes-to-replicated-tables

And has the situation changed in later versions of Nav or Business Central?
Alastair Farrugia

Categories