How to compare the database(Microsoft SQL Server 2008 R2)?

Posted by Manohpr under Sql Server on 3/7/2012 | Points: 10 | Views : 2106 | Status : [Member] | Replies : 0
Hi Guys,

I want to know "How to compare the database(Microsoft SQL Server 2008 R2).

I frequently changes to my databases and database schemas. I have stagging and production databases. In my database have 250 and above stored procedures. I missed some stored procedures during migrating to production. I want to know the following list of changes made this release.

. Tables
. Columns
. Foreign Keys
. Views
. Stored Procedure
. User Defined Types
. User Defined Data Types
. XML Schema Collections
. Defaults
. Function
. Assemblies
. Users
. Roles
. Schemas

Please let me know any free software or Execute any SQL scripts.

If we found something, I hope its more useful for all SQL developers


(No response found.)

Login to post response