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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy