Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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