SSIS Package to find out difference between SQL server Objects

1.3k Views Asked by At

How to create an SSIS package to compare SQL server Database Objects in different servers and generate the difference in an Excel Sheet. Is it possible to do that?

1

There are 1 best solutions below

1
On

SQL Server Data Tools (SSDT) for Visual Studio 2012

SQL Menu > Schema Compare > New Schema Comparison...

Allows you to point to two different databases, then...

  • The Options button (looks like a gear) allows you to set filters on what is being compared, i.e. tables, views, SP's, users, etc.
  • Hit the Compare button to compare the two db's, and list all differences
  • Allows you to check / uncheck all differences to be updated or not, and
  • The Update button executes the above changes.

This isn't an SSIS package, and can't dump differences into Excel (afaik), but it can generate SQL Script of all changes.