Meta-Data Copying in MS SQL Server

Hey experts,

I have on MS SQL Server one base DB, and 5 additional DBs which are similar to the first, but they have no data (or at least they have different data from each others and from the base DB). The base DB is the one that is used for testing the software on it, when something appears wrong in the meta-data of this base DB it is being corrected on it (like a field in a table which turns out that it should accept a NULL value or have a default value); this change in the meta-data of the base DB means that I have to do the same change in the 5 other DBs. Is there any way that could allow me to copy the new state of the base DB's meta-data onto the other 5 DBs (using some Stored Procedure or something similar), so I don't have to keep on repeating the changes that I do everytime, 5 times??
LVL 3
mte01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arbertCommented:
Sounds like you need a modeling tool that can generate change scripts (Sybase Powerdesigner, Erwin, Xcase, etc).  However, redgate software offers SQL Compare that can do some pretty remarkible stuff as well:  http://www.red-gate.com/

Brett

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mte01Author Commented:
It looks great!!.....I'll have a look at it, and I'll inform you of the results......
mte01Author Commented:
The tool is fine......thanks for the link!!
arbertCommented:
You bet--they do have some very nice products!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.