Compare SQL Server database schema

I am working on project (VS2010 .NET) and have two SQL Server databases, Dev and Prod.

I make all database structure changes in the Dev database and after testing I apply the same changes to the Prod database.

Maybe someone could suggest schema comparison tool which could help me to compare structure and apply changes.

Upvotes: 3

Answers (4)

Lynn Langit

Reputation: 4060

You can also get SQL Server Data Tools (SSDT) (free) here - more about SSDT on my blog.

Upvotes: 3

sawe

Reputation: 1151

although you are working in 2010, if you can get hold of VS 2012

go to SQL (menu item) -> Schema Compare. Click on Select Source on the left, and select the dev database. Select the production database on the right.

Then click on the generate script icon (next to the Update icon, it looks more or less like a music icon). That will generate the update script. You may also untick any of the changes that you do not want to include in the script. And it is ... 'free' if you happen to own Visual Studio 2012

Upvotes: 0

marc_s

Reputation: 754230

I know of two really good tools:

Upvotes: 3

JohnC

Reputation: 842

RedGate makes excellent tools for the purpose.

Upvotes: 3

Compare SQL Server database schema

Answers (4)

Related Questions