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.
. Foreign Keys
. Stored Procedure
. User Defined Types
. User Defined Data Types
. XML Schema Collections
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