Compare tools to generate update script for SQL server [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 10 years ago.

Improve this 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.

See duplicate question already asked: Best tool for auto-generating SQL > change scripts for SQL Server — Ray
– Ray, Commented Nov 14, 2008 at 18:43

John Sheehan · Accepted Answer · 2008-10-06 21:46:04Z

12

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

answered Oct 6, 2008 at 21:46

John Sheehan

78.3k30 gold badges162 silver badges194 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pittsburgh DBA Over a year ago

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.

edosoft Over a year ago

Very nice! I've had good success with Red-Gate but this one has better value for its price!

Jereme Over a year ago

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.

Community · Accepted Answer · 2017-05-23 12:01:23Z

1

I answered the same question here.

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

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Oct 6, 2008 at 22:11

Pittsburgh DBA

6,8042 gold badges44 silver badges71 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:08:36Z

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.

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Oct 6, 2008 at 21:45

harpo

43.5k15 gold badges102 silver badges133 bronze badges

Comments

VinceMD · Accepted Answer · 2011-02-10 08:06:07Z

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.

answered Feb 10, 2011 at 8:06

VinceMD

1111 silver badge7 bronze badges

Comments

William Johnson · Accepted Answer · 2013-08-02 09:18:14Z

0

Here are couple more to add to the list:

ApexSQL Diff (schema compare) and ApexSQL Data Diff (data compare)
Comparison toolset
Adept SQL Diff

answered Aug 2, 2013 at 9:18

William Johnson

1901 gold badge1 silver badge6 bronze badges

Collectives™ on Stack Overflow

Compare tools to generate update script for SQL server [closed]

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Linked

Related