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

How to Ignore All Formatting in Stored Procedures?

homermlhomerml Posts: 4 New member
edited September 15, 2017 8:51AM in SQL Compare
I need to compare two databases that are running the same database but the developer version has been updated. Most of the Stored Procedures (100's) have been formatted to make them more human readable. So they have spaces and new lines (carriage returns) inserted everywhere. When I do a compare, it brings back all Stored Procedures. I've tried looking / playing the options but nothing has helped. This seems a good program but have I missed something?
Tagged:

Comments

  • Options
    Have you tried the Ignore Whitespace option? If you click "Edit Project" it should be on the "options" tab. You can also ignore other differences such as comments, case and square brackets.

    qaegcrdrtqad.png
    Software Developer
    Redgate Software
  • Options
    homermlhomerml Posts: 4 New member
    Yep, tried that.
  • Options
    Sorry to hear Compare isn't working as you'd expect. Would you mind contacting support@red-gate.com with some more information so we can figure out what's going wrong? It would be useful to have:
    - Some example SQL on both sides that reproduces the issue
    - The version of Compare you are using (this can be seen in the About box on the Help menu).
    Software Developer
    Redgate Software
  • Options
    homermlhomerml Posts: 4 New member
    Version 13.0.1.5078
  • Options
    homermlhomerml Posts: 4 New member
  • Options
    So this a good example where it's not obvious to us how Compare should behave, because there are real differences in addition to the whitespace you want to ignore. What would you expect to see here? Should we stop showing the text line by line, for example, or reformat the text on one side to match the other?

    If you deployed this change, there's currently no way for Compare to apply the formatting on the right to the lines of SQL that contain real differences. We have a number of proposed suggestions for this, including the idea of sharing your SQL Prompt formatting options with Compare, but we think further research is required to decide how that should work.
    Software Developer
    Redgate Software
  • Options
    KamilKamil Posts: 1 Bronze 2
    Hi guys,
    And what about such simple differences with brackets only?
    Obviously, I've ticked the option "Ignore square brackets in object names".
    I've got the latest version of Redgate Compare: 13.0.5.5219.
    Could you help, please? Currently, I have tons differences because of that only.
    76hyb30yorxx.png
  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    edited October 31, 2017 2:54PM
    Hi @Kamil ,

    It seems to work fine for me. I've tested in version 13.0.5.5219 and 13.1.2.5327. We have created a ticket for you so that we can look into the issue for you in detail.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.