10

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.

HAXEN
  • 388
  • 1
  • 2
  • 13
  • See *duplicate* question already asked: [Best tool for auto-generating SQL > change scripts for SQL Server](http://stackoverflow.com/questions/10688/best-tool-for-auto-generating-sql-change-scripts-for-sql-server) – Ray Nov 14 '08 at 18:43

5 Answers5

12

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

John Sheehan
  • 77,456
  • 30
  • 160
  • 194
  • Nice. I will have to evaluate this one. I'm a long-time Red-Gate user, so this may be refreshing, especially for clients where budget is a concern. – Pittsburgh DBA Oct 06 '08 at 22:09
  • Very nice! I've had good success with Red-Gate but this one has better value for its price! – edosoft Oct 07 '08 at 14:52
  • We actually bought this tool. It's nice, but there are a few usage flow annoyances that would be easy to do and really help make it a better product. It does not seem like it is being actively developed though. – Jereme Jul 06 '21 at 00:25
1

I answered the same question here.

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

Community
  • 1
  • 1
Pittsburgh DBA
  • 6,672
  • 2
  • 39
  • 68
0

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.

Community
  • 1
  • 1
harpo
  • 41,820
  • 13
  • 96
  • 131
0

Here are couple more to add to the list:

William Johnson
  • 190
  • 1
  • 1
  • 6
0

so far, satisfied with RedGate. We use SQL version control + SQL Compare. I've integrated it with Msbuild and Hudson. So that give us a complete continuous integration solution.

VinceMD
  • 111
  • 1
  • 7