Replicate schema object changes, within same database

I have a single database instance. I have many schemas in it. If there is any DDL change (create / update / delete) in stored procedure or table for 1 schema, then I have to do that change in all other schemas on same database. Which is best method of doing that?

Powershell is a nice method for that kind of stuff

have you looked into DDL triggers?

1 Like