SQLTeam.com | Weblogs | Forums

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?