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.