Automatically Generate migration script
Here is the scenario I going about. During iteration several developer does their check-ins and they do not create a migration script since then on Databases. But when it time to push build its a pain to go back to previous version of database and generate migration script using SQL Compare. Can't we have an option to generate a script right from SSMS by doing a diff between the two checked in revision in version control. Also another idea may be to allow create snapshot right from SSMS and developer can generate a script from that snapshot. We can have some manual process to achieve this but y not have a integrated solution to this problem.
The SSMS Integration Pack, which comes with SQL Compare Pro 8.50, can generate migration scripts between 2 versions in source control. For more information, please see http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare/help/8.50/ssmsip_deploy_soc.htm&toc=SQL_Compare/help/8.50/toc1280663.htm.
We're currently implementing functionality to solve this. Which is more important? 1) To get a migration script between two labels/tags? 2) or to get a migration script from two artibrary revisions?