THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Comparison of SSMS and Visual Studio for Development

Either SQL Server Management Studio (SSMS) or Visual Studio can be used for database development. I put them side by side into a single composite screen capture where you literally see the gaps between the products. SQL Server 2012 was installed with all features selected and default settings. The only modifications to the SQL Server installation were the additions of the AdventureWorks2012 and AdventureWorks2012DW databases.

Using Visual Studio instead of SSMS for database application development gives you the advantage of integration with Team Foundation Server for source code control. Additionally, localdb gives you a way to debug stored procedures locally in case your DBA won’t grant you sufficient rights to debug on the database server. You can copy your production schema to your localdb and debug from within Visual Studio.

image

Figure 1. SQL Server 2012 Management Studio on the left, Visual Studio 2013 on the right. Screen captures made on Windows 8.1.

Published Friday, March 07, 2014 10:03 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Greg Low said:

Hi John,

While DB projects are in some ways richer in VS, you can use SSMS and SQL script projects with TFS as well. We do this all the time. You have to install the SCCI provider: http://visualstudiogallery.msdn.microsoft.com/bce06506-be38-47a1-9f29-d3937d3d88d6

HTH,

Greg

March 9, 2014 7:36 PM
 

jamiet said:

You also don't need LocalDB to do debugging. I use the debugging feature against Standard & Enterprise all the time. I use LocalDB a lot also because I love how lightweight it is, but it doesn't have any features that a locally installed "regular" instance does not have.

I will say I much prefer source control integration in VS than the way it has to be crowbarred into SSMS.

nice post John

March 10, 2014 4:26 AM
 

John Paul Cook said:

The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

 

That's the message I see when I try to debug on any of the servers at my primary client. This is not uncommon to see such restrictions. When the required permissions aren't granted to developers, localdb allows debugging of local copies of stored procedures whose originals reside on locked down servers. 

 

March 10, 2014 7:05 AM
 

manson said:

great comparison

March 13, 2014 1:30 AM

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is a Technology Solution Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement