aaron.reese (4/21/2015)
+1 for RedGate.They also have a data compare so that you can script config and static data
Their tools also integrate very nicely into SSMS and SQL compare can handle scripting from source code repository (Subversion, Mercurial or TFS)
You can download a fully working evaluation copy
Plus they are the primary source of funding for this site
Not an employee, just a happy customer
Thanks!
And you can call them all from the command line and automate the processes.
And I do work for them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning