May 2, 2002 at 7:46 am
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
May 2, 2002 at 8:28 am
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)
May 2, 2002 at 9:15 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply