Top 10 SQL Compare Tips. Watch now.
Is there a way to omit synonym comparison?
I'm attempting to compare two vendor-created schemas (prod & test). The vendor uses synonyms heavily (500k of them...its ridiculous). These are useless for my comparison purposes, since I only want to check table/view/stored procedure changes. Unfortunately the comparison takes a really long time to process, presumably because of the volume of synonyms. Is there an option to not compare synonyms at all to cut down on processing time? I've only been able to find the option to remove them from the view AFTER the comparison runs.
0 · Share on Twitter