What are the challenges you face when working across database platforms? Take the survey

Format object before compare

BertBBertB Posts: 4
edited November 12, 2015 12:44PM in SQL Compare 11
Is there a setting to format the object (SQL Procedure) before the compare? I have modified procedures that are very long and when I compare to new released versions for our product, the procedure is scripted out in one line, which makes the comparison almost worthless. If the objects could be reformatted (remove white space) and then formatted via the same algorithm, the compare would be a whole lot more useful. Does this feature exist?

Thanks for any help.



  • Options
    Hello Bert,

    Thanks for you question about SQL Compare and whitespace. We don't have a way for our tools to format the whitespace before the compare but we do have an option that ignores whitespace. This option is normally on but in your case it may be worth it to turn it off and see if this solves the issue.
    Allen LeVan
    Red Gate Software
    US Product Support
Sign In or Register to comment.