I need to find the best way to make changes to all metadata my databases.
1. We can do it manually :(
2. We can use merge replication (needs investigation)
3. We can write our own scripts.
search all instances for a metadata database
if db exists check to see if the change exists (ie. new constraint, new column,cell value)
if it doesn't exist ALTER TABLE
send a mail back to DBA for each change made and where
What do you think is the best way?
-Kevinyou can use 3rd party software from www.red-gate.com
No comments:
Post a Comment