support for "create or alter" syntax on proc scripts

KevArnoldKevArnold Posts: 3
in SQL Compare
We are using the SQL server syntax "create or alter procedure" for stored procedures. SQL Compare mistakenly considers this a syntax error. Is there any setting or change to have this syntax supported?
Tagged:
· Share on Twitter

Comments

  • Mark JMark J Posts: 125 Bronze 5
    Unfortunately not at the moment - CREATE OR ALTER is a 2016 SP1 feature that Compare doesn't recognise yet. It's on the backlog to get into Compare soon, though
    · Share on Twitter
  • KevArnoldKevArnold Posts: 3
    Thanks for the quick response. I will watch for it in a future update.
    · Share on Twitter
  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    We've released 12.4.0.4551 to our frequent updates channel, which should support this new syntax. Does it work as you expect?
    Software Developer
    Redgate Software
    · Share on Twitter
  • KevArnoldKevArnold Posts: 3
    edited August 10, 2017 9:16PM
    Hi @sam.blackburn

    Sorry I missed the post in May. I did install the latest compare version and it has 2 bugs. The one that makes this unusable is the deployment script changes the "create or alter" to "alter or alter". This causes a failure in the script.

    The second is the compare considers the "CREATE or ALTER" to be different than what is in the DB. It should compare as being the same to make it simple to know that the objects are up to date.

    3ns3upbmry5c.png

    zvnq52akx44e.png





    · Share on Twitter
  • Andrew PAndrew P Posts: 194 Silver 3
    Hey Kev,

    The devs have created bug number SC-9645 for that issue and are currently investigating.
    Do let us know if you have any additional questions in the meantime!

    Warmly,
    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.