Store procedure to compare two Database objects

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Store procedure to compare two Database objects

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2010-08-09 : 08:13:52

Hi,

I want a store procedure that compare all object(table,stored procedure,view,trigger) between two database and return list of changes have done from database1 to database2.Actually i want store procedure for database versioning purpose ,i do't want any Tool for this.

Thanks & Regards.

Ranjeet Kumar Singh.

Ranjeet Kumar Singh

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-08-09 : 08:18:19

you want to do with T-SQL then you can get the list of different objects
but list of changes is not that much easy with T-SQL.
Please explain more what exactly you want ?

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2010-08-09 : 08:23:26

Thanks for reply .yes i want list of changes with T-SQL
like this link http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=27234

This link's stored procedure not work proper.

Ranjeet Kumar Singh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources