How can we help you today? How can we help you today?

support for "create or alter" syntax on proc scripts

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?
KevArnold
0

Comments

5 comments

Sort by
  • Mark J
    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
    Mark J
    0
  • KevArnold
    Thanks for the quick response. I will watch for it in a future update.
    KevArnold
    0
  • sam.blackburn
    We've released 12.4.0.4551 to our frequent updates channel, which should support this new syntax. Does it work as you expect?
    sam.blackburn
    0
  • KevArnold
    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





    KevArnold
    0
  • Andrew P
    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 P
    0

Add comment

Please sign in to leave a comment.