Deploy database changes, SQL COMPARE tool

What type of SQL COMPARE tool do you recommend for the below ?
Current Steps
1.      I make changes to my test database structures (add/delete columns, change PKs, add UNIQUE constraint), etc
2.      I create SQL ALTER table scripts
3.      I repeat #1 and #2 multiple times during a 30 day time frame
4.      I then update PROD with the most current SQL ALTER table scripts
Desired Steps
1.      I make changes to my test database structures (add/delete columns, change PKs, add UNIQUE constraint), etc
2.      At the end of a 30 day time frame I click “TRANSFER to PROD” which does all the work, no longer having to keep creating ALTER table scripts during the 30 day period
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.

Brian CroweDatabase AdministratorCommented:
I use RedGate's SQL Compare which is very easy to use.  I'm sure it can be scripted to run automatically but I prefer to run it manually just to double-check any changes before committing anything.

The tool is very simple and intuitive to use in my opinion.

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
Aneesh RetnakaranDatabase AdministratorCommented:
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I can recommend also the apex sql software suite for this kind of tasks.
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.