SQL Server Management Studio 2012 + VS 2010 Shell relationship, especially extensibility

Question

Now SSMS 2012 has been released, how does the VS 2010 extensibility model apply to SSMS 2012.

The first area I'm interested in is the overlap in the rich extensibility tools set for source control that currently exists in the Visual Studio ecosystem and in and how that might apply to SSMS? At the moment the Source control, in SSMS 2012 seems to be the now, very dated, MSSCCIS provider model.

The second area I'm interested in is around Nuget Packages and using it for SQL template distribution. I can't see any nuget goodness at this stage. Is it coming?

I was really hoping that the might be some overlap in the extensibility models between the two, but out of the box, that doesn't seem to be the case. Can anyone point us to the correct direction for this topic?  It would be nice if there was a little competition with Red-Gate for SQL Server components in SSMS.

---

Jamie Clayton http://www.jenasysdesign.com.au

Answer 1

After searching around, it looks like Buck Woody, the SQL Server manager has ruled out official support of ANY extensions to SSMS via a Connect issue for the 2012 edition.  The Books On Line also include a similar, rather disappointing statement as well.  I hope that the SQL team can push this as a higher priority for a service pack, or how they handle VS 11 release and if they will migrate SSMS to that shell environment.  

Personally I find it hard to understand why SSMS solutions/project with lists of *.sql files couldn't have access to the same features/Addins the the Visual Studio developers have for solutions files, aka alternate source control addins.  Both are just a list of files.  Got to say, that with the increase in licensing fee's that Microsoft has introduce in this edition, comes with a significant increase in expectations, features and performance from a developer and customers point of view.

---

Jamie Clayton http://www.jenasysdesign.com.au

Answer 2

HI

Thank you for updating this issue.

And Thank you for your understanding of support.

Yi

---

Yi Feng Li [MSFT]
MSDN Community Support | Feedback to us