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.
Anonymous
shared this idea
We’ve released SQL Prompt 6 which includes full synonym support.
-
Patrick Cunningham
commented
This is very important for old database migration.
-
Steve Smith
commented
SQL prompt needs to support synonyms with linked servers becoming more of a mainstream technique.
-
Alessandro Alpi commented
I used a lot the synonyms solution to migrate old schema based database or to call linked server objects. So i agree with you. Thanks.