Sql-server – Transactional replication – Table / Stored Procedure changes coming over, but not new Tables / Stored Procedures

sql serversql-server-2017

I've set up transactional replication between my on-prem database (SQL 2017) as a publisher and Azure as a subscriber.

My CHANGES (insert / update, alter stored procedure, alter table, etc) are coming over, but my NEW stored procedures aren't. In SSMS 17, I went into Replication > Local Publications properties and checked the new stored procedure in the [Articles] tab, but it's still not making it over.

It's not clear what I need to do to get the new stored procedure to come over. I looked at sp_addarticle but it looks like it would be the same that I did with the checkboxes in the GUI.

Best Answer

New objects need to be added since they are not part of the original publication when you established replication between the publisher and subscriber.

You can add objects to the existing publication w/out needing to stop replication activity. Please see this link and the section titled "Replication Maintenance"

Related Question