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