Compare tools to generate update script for SQL server

Question

I would like to make the update of the web application as automated as possible.
I'm looking for a tool that can compare two instances of a database and generate an update script for me. As part of the build process create a instance of the last version of the database (ie currently in production) and compare that to what has been changed on the development version.

Any input is appreciated.

Answer 1

See

Mechanisms for tracking DB schema changes

I believe the profluence of this question on SO speaks to the lack of a standard solution to this problem.

The great divide in approach is
- write delta scripts
- automate script generation from a "master" instance

It sounds like you want something in the latter camp.

Several such solutions and tools are noted in the above question.

Answer 2

I like SqlDbDiff. Way cheaper than RedGate's SQL Compare

Answer 3

I've had good luck with AdeptSQL. The last time I tried RedGate, it generated a schema script file for each database compared and then diffed the files. That can really take a while for large DBs. Adept just generates diff scripts in memory. It's very fast. Not the cheapest tool, I guess.

I think most tools have trials. Maybe download a few and test drive them.

Answer 4

I answered the same question here.

Best of luck! As you will see, I like the Red-Gate tools.

Answer 5

See duplicate question already asked:

Best tool for auto-generating SQL change scripts for SQL Server

Answer 6

In case if someone is still interested with this thread, we would like to pay your attention onto our dbForge Schema Compare for SQL Server, that has got such functionality.