How to compare triggers in two different MSSQL DBs?

[quakefiend420]

I have a database that has a few hundred triggers(many of them are a few thousand lines) in it, there were several changes that were made to the triggers to resolve certain issues. Unfortunately, the person who made the changes didn't document them and isn't around to tell me what he did. I do have a backup of the DB that contains the changes, however.

Both DBs are SQL8, I have another copy of the DB that does not contain the changes. Is there an easy way to pick out the trigger changes between the two without manually comparing each trigger line by line?

Thanks in advance!

 

[KIAman]

I have a database that has a few hundred triggers(many of them are a few thousand lines) in it, there were several changes that were made to the triggers to resolve certain issues. Unfortunately, the person who made the changes didn't document them and isn't around to tell me what he did. I do have a backup of the DB that contains the changes, however.

Both DBs are SQL8, I have another copy of the DB that does not contain the changes. Is there an easy way to pick out the trigger changes between the two without manually comparing each trigger line by line?

Thanks in advance!

Run them through a diff editor. I like Winmerge. This will show the textual differences. It won't show you how functionality has changed, that is up to your interpretation.

 

[KLin]

http://opendbiff.codeplex.com/

Just found this via google search. Never used it.

 

[LokutusofBorg]

RedGate has tools that can do it from the databases. I'm sure there are others (KLin's link? didn't follow it myself, sorry...)

Otherwise, script all the objects to file and use your file compare tool of choice.

 

[KLin]

I just tried the one that I linked to and it worked fine. I only had a couple columns that were not in one copy that I had. it generated a script to create the columns.