How can I compare 2 sql server databases schema and get the update script

Question

I'm not sure if there is such a tool... given 2 sql server databases, I want the tool to tell me what is different between the 2 and give me the update script. I.e. create indexes, create table, create relationship, etc... I don't need data comparing, just schema.

This looks like it would be useful. https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx — Paul Zepernick, Jan 22 '15 at 02:41
possible duplicate of [What is a free tool to compare two SQL Server Databases?](http://stackoverflow.com/questions/193438/what-is-a-free-tool-to-compare-two-sql-server-databases) — johnny, Jan 22 '15 at 03:00

score 3 · Accepted Answer · answered Jan 22 '15 at 02:46

3

This one is really popular, but it's not free.

Apex SQL

If your using SQL Server 2005 or 2008. You can try these

SQL Server Database Comparison Tool

DB Comparer

You can also use the Schema Compare option in SSMS.

answered Jan 22 '15 at 02:46

Arun

941
6
13

score 1 · Answer 2 · answered Jan 22 '15 at 03:00

1

Visual Studio Premium and Ultimate versions come with a Schema Comparison tool (TOOLS | SQL Server | New Schema Comparison...)

There is more information here

answered Jan 22 '15 at 03:00

DeanOC

7,142
6
42
56

score 0 · Answer 3 · answered Jul 28 '16 at 18:03

0

Sql Server Data Tools (SSDT) has a schema compare tool, with an option to generate an update script. The example image below is version 2015.

answered Jul 28 '16 at 18:03

James Wierzba

16,176
14
79
120

score 0 · Answer 4 · answered Oct 07 '16 at 08:28

Try xSQL Schema Compare. It can compare any object in the database and generate synchronization scripts for all of the differences or just the ones you choose. Also, you can use it for free if you are using SQL Server Express.
Disclosure: I'm affiliated with xSQL.

How can I compare 2 sql server databases schema and get the update script

4 Answers4