SQL Server 2005 Synonyms not supported in 3.5?

Comments

• Options

  JasonC Posts: 85

  July 27, 2007 7:30AM

  I'm afraid synonyms are not supported in SQL Prompt 3. Synonyms, like you're using them, are usually used for objects on different DBs or Servers. A such, supporting them would create many issues of authentication and security. But we would like to support them in future versions of SQL Prompt, but we can't say whether we will support this in the next version.
  
  Thanks for your input, we always like to know what people are using SQL Prompt for.

  Jason Crease
  Red Gate Software

  0 · Share on Twitter
• Options

  DavidHerbst Posts: 13

  July 27, 2007 5:38PM

  Thanks for your response Jason and I understand that you there may be difficulties that prevent this from being implemented in the near future.
  
  What I don't understand is how the authentication and security issues would be different than the ones you've already solved for the "Cross database queries" support you added in the 3.5 release.
  
  Synonyms are just aliases, authentication and security is still based on the underlying object they are pointing at. See code example below.
  
  Am I missing something here?
  
  E.g.

  USE OtherDb
  
  CREATE SYNONYM dbo.CreditCard FOR AdventureWorks.Sales.CreditCard
  
  -- Either both of the following queries will fail or both of them will succeed based on authentication and security settings.
  
  SELECT *
  FROM CreditCard
  
  SELECT *
  FROM AdventureWorks.Sales.CreditCard
  

  0 · Share on Twitter
• Options

  JasonC Posts: 85

  July 31, 2007 6:09AM

  SQL Prompt would need to parse and use synonyms that could potentially be much higher up in the code, and prompt the user for authentication details accordingly. You are correct that the abilities to do these tasks is largely already in Prompt, but wiring it all together in a usable way will probably have to wait for the next major release.
  
  In your code example, I see what you're saying. But say the user opened this query from a file. He would need to immediately be prompted for authentication details for Adventureworks before Prompt could give meaningful intellisense. The problem we need to solve is that when opening a large file with lots of synonyms, the user would be immediately prompted with dozens of dialogs asking for passwords. So in some ways it's more of a usability issue than an engineering one.
  
  Thanks again for your suggestions - this is precisely the sort of feedback we need to help build the next version!

  Jason Crease
  Red Gate Software

  0 · Share on Twitter
• Options

  sirbasku Posts: 1

  August 31, 2007 11:24AM

  I love intellisense! We use synonyms for easy configuration between stage and production database linking and we sure would vote for synonym support in intellisense! Almost all our new BI development systems use synonyms so source systems are transparent to the developers and testers. All the procs now just reference a synonym and it is the DBA's job to make sure the synonyms are pointing at the proper system (develop/stage/production). It has really helped our small team stay agile, but now all our cool new BI projects are making me code with an explicit reference if I want the intellisense then I have to go back and change the explicit objects with the synonym names. It would be great if synonyms were just treated like the other database objects and security just worked the same as it does for accessing all the stuff it caches now.

  0 · Share on Twitter