Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: changes across all db's

    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?


  2. #2
    Join Date
    May 2002
    you can use 3rd party software from

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts