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.

share
add comment

2 Answers

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

share
    
Some of us are, unfortunately, forced to use SQL Server databases, and in that case, Microsoft simply does have the superior software. –  Ben Brocka Nov 6 '11 at 2:00
add comment

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.

share
add comment

You must log in to answer this question.

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