How can we improve SQL Prompt?

Synonym support

I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for its columns etc. This renders SQL Prompt's auto completion and suggestions useless in many cases for us.

234 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Luke JeffersonAdminLuke Jefferson (Admin, Red Gate) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Dan SullivanDan Sullivan shared a merged idea: SQL Prompt does not seem to know about synonyms.  ·   · 
    Pravin D. PatilPravin D. Patil shared a merged idea: Synnonym are not displayed  ·   · 

    25 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • StephenStephen commented  ·   ·  Flag as inappropriate

        At the moment it's in the "Experimental Features" section. As at October 19, 2012, no COLUMN prompting is available.

      • Justin CaldicottAdminJustin Caldicott (Admin, Red Gate) commented  ·   ·  Flag as inappropriate

        A little update. The next release (5.2.2.1) that I referred to is now already complete, and synonym support was started about a week ago. We are moving to a more frequent release cycle for development changes to our early access list. We're keen to get your feedback on our implementation of this feature, so if you would like to receive more regular updates then please sign up to our early access list here: https://www.surveymk.com/s/DZLN2JW Thanks!

      • PetrPetr commented  ·   ·  Flag as inappropriate

        If synonym support is not planned within one year, I'm not going to buy upgrade for next year...

      • Vinod MishraVinod Mishra commented  ·   ·  Flag as inappropriate

        I have waited more than a year for this feature and it seems SQL Assistant supports synonyms just fine. I do prefer SQL Prompt but I think I will move to SQL Assistant as it has all the features I want.

      • Klaus OndrichKlaus Ondrich commented  ·   ·  Flag as inappropriate

        @Justin: Thanks for the update. However, it is quite unsatisfactory. Synonym support has been in the queue (at least) since SQL Prompt 4. Now we currently stand at version 5.2 and hear that it will not be available in the next release. That's very disappointing and reduces SQL Prompt's value extremely, since we completely rely our database development on synonyms (in fact SQL Prompt is just useful for in-database objects, since all "remote" objects are made local through synonyms).

      • Justin CaldicottJustin Caldicott commented  ·   ·  Flag as inappropriate

        Thanks for the input and patience! This is something that we do intend to address. It’s quite an involved change and won’t make the next release, but we’ll update this page with progress.

      • Stephen AnslowStephen Anslow commented  ·   ·  Flag as inappropriate

        This has been "Under Review" for OVER SIX MONTHS.

        Not wishing to be rude but this is far too long a "review" window.

        With 176 votes at the time of posting, you (RG) appear to have a decent amount of clamor in the community.

        UPDATE PLEASE!

      • Nathan BedfordNathan Bedford commented  ·   ·  Flag as inappropriate

        RedGate, this is a pretty critical issue for us too! Can you give us an ETA? Will this make it into the next release?

      • Stephen SoltStephen Solt commented  ·   ·  Flag as inappropriate

        just wanted to add my comment. Synonyms are really useful for moving from test to production environments and keeping SQL code as general as possible.

      • Michael SumeranoMichael Sumerano commented  ·   ·  Flag as inappropriate

        Synonym support has been added to SSMS for SQL Server Denali. You can downloat the current CTP to see it in action.

      • BreadonBreadon commented  ·   ·  Flag as inappropriate

        I find them much more flexible to use than LinkedServers. Uses include preparing for server consolidation ie when a database changes server. Unlike when using views, the column list will reflect an underlying table when the underlying schema changes.

      • Lars WislerLars Wisler commented  ·   ·  Flag as inappropriate

        Synonyms are not only smart but also getting more and more "common", so full synonym support is a must whereever used.

        So please add this to make a great product even greater! :-)

      • StephenStephen commented  ·   ·  Flag as inappropriate

        Just used my first synonym and oh, the disappointment of having NO suggestions... Deep woe... Hope the "Under Review" elicits a "Started" status v. soon...

      • smsm commented  ·   ·  Flag as inappropriate

        We have started using synonyms, and I would like to vote for the synonym support by SQL prompt.

      ← Previous 1

      Feedback and Knowledge Base