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?
-Kevin
-
Personally I would go the scripts route as you have a record of the changes made. Manual would be my next suggestion. Merge may cause issues.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
Manual is probably the best.
Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply