How to produce an incremental DDL script?

Question

Mine is a SQL Server database.

Suppose I have two DDL scripts, one old and one new. I want to compare the old and the new scripts and generate an incremental script which can be run on the database of old script and finally a database that represents the new script is prepared.

Is there such a tool / utility?

Answer 1

Many

Possibly the best known is the Red Gate Compare which costs money.

There are severalfree tools highlighted in these 2 threads though (I won't copy paste)

• What is best tool to compare two SQL Server databases (schema and data)?
• https://stackoverflow.com/questions/377388/are-there-any-free-alternatives-to-red-gates-tools-like-sql-compare