Why should I use Visual Studio 2010 over SSMS for my database development?

Nick and I got into a discussion via various places on the Stacks and he felt encouraged to ask it as a question on dba (and then he asked on chat.dba.se if this was appropriate). Since I'm too close to the question, I can't really make a good judgement call.

So what do you, the community, think? This is, after all, a community run site.

2 Answers 2


At first, I was going to say 'no', since the question title seems argumentative and too subjective.

Then I opened the question and found that what it really was asking was what does VS2010 offer that SSMS doesn't. Seems like a great question for DBA, since these are tools DBAs1 use.

1DBAs in this case = microsoft toadies!2

2These are my opinions only

  • 1
    Some of us are, unfortunately, forced to use SQL Server databases, and in that case, Microsoft simply does have the superior software.
    – Ben Brocka
    Commented Nov 6, 2011 at 2:00

From the responses to @Nick's question so far, it would appear the capabilities of VS2010 for database development are not well understood. As such, this has the potential to be a useful signpost for the community.

As @DTest mentions, it could be interpreted as a subjective question but hopefully the answers will make it less so.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .