Making changes to a table that is included in SQL Replication

afarr
Member Posts: 287
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?
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
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions