The publish SQL does not publish stored procedures.... Schema only. Not a good idea.

 

I will be giving a small demo in virtualtechdays , will be using this video for reference. Let me know if its fine. Awesome explanation