SQLTeam.com | Weblogs | Forums

Replicate schema object changes, within same database


#1

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?


#2

Powershell is a nice method for that kind of stuff


#3

have you looked into DDL triggers?