SSMS or SSDT

  • badOedipus

    SSC Enthusiast

    Points: 170

    Used both, prefer SSMS.

  • Christopher Reed

    SSC-Addicted

    Points: 490

    I use both, but I've probably been using SSDT since I'm doing more with SSRS.

    Christopher Reed, MCT, MCSD, MCPD, MSpec, MTA, MCTS
    "The oxen are slow, but the earth is patient."

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715334

    Comments posted to this topic are about the item SSMS or SSDT

  • Gary Varga

    SSC Guru

    Points: 82166

    Historically I have used both but SSMS substantially more (even in the time frame when they both have existed).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • shillbot

    SSC Journeyman

    Points: 82

    I'm primarily a C# developer (with a heavy DB focus), and I spend most of my time in Visual Studio, but I find SSMS more comfortable for DB work (with an add on or two).

  • Phil Parkin

    SSC Guru

    Points: 243596

    I use both.

    In a shared environment (multiple devs to one DB) I find SSMS works better than SSDT.

    But if you can get to the point where you do your dev on a local instance, SSDT is my preferred environment. The ability to build and publish is very cool and integration with source control works better.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • P Jones

    SSChampion

    Points: 12323

    Management Studio open all day for database management and sql querying then either Visual Studio 2008 for SSIS/AS/RS development as we're on SQL 2008 for those or Visual Studio 2010 for ASP.NET development.

  • Gary Varga

    SSC Guru

    Points: 82166

    My emphasis:

    Phil Parkin (3/27/2015)


    ...SSDT is my preferred environment. The ability to build and publish is very cool and integration with source control works better.

    Good point.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Alan Burstein

    SSC Guru

    Points: 61029

    others bemoan the demise of isql/w

    Yep. I was one of those people. This thread brought back some memories.

    I do all my SQL in SSMS. SS%S happens in Visual Studio.

    -- Alan Burstein


    Helpful links:Best practices for getting help on SQLServerCentral -- Jeff ModenHow to Post Performance Problems -- Gail ShawNasty fast set-based string manipulation functions:For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)To split strings based on patterns try PatternSplitCMNeed to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8KI cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code.  -- Itzik Ben-Gan 2001

  • Sue Callaghan

    SSC Enthusiast

    Points: 196

    I use SSMS almost exclusively.

    Used to use Enterprise Manager and ISQL but don't really miss the latter much!


    Cheers,

    Sue

  • SebastianCrewe

    SSC Rookie

    Points: 48

    My work involves both maintenance/enhancement of existing databases and the creation of wholly new databases. For the former, I'd most likely use SSMS since it is easier to experiment on views and procedures there. For a new database, my preference is for SSDT.

    SSDT offers easier methods for linking to source control (Ankh to Subversion), the more so since not all the developers here have the Red Gate toolset (including SQL Source Control). I also find the table scripts made in SSDT are more appealing - as well as the table definition, all foreign keys, constraints, triggers and permissions are in the one script. The use of variables in an SSDT project means that I can deal with environment-specific users in a generic way. I can also have several related databases in a single solution (eg Staging and Warehouse).

    Sebastian

  • erwin oosterhoorn

    SSCrazy

    Points: 2002

    I work with creation of new SQL code as well as maintenance, and due to the different servers and versions I use SSMS almost exclusively.

    but also use Enterprise Manager as this is still on some of the servers we have to work with.

    Health care is not one of the areas where a lot of money is available for upgrades.

  • Rune Bivrin

    SSCertifiable

    Points: 7551

    ISQL/W... Pftt! New-fangled stuff.

    I remember when I did most of the work in SAF on SQL Server 1.1. Those were the days...


    Just because you're right doesn't mean everybody else is wrong.

  • Todd Townley

    Ten Centuries

    Points: 1258

    Never tried SSDT, so SSMS exclusively. For one thing, it doesn't require the additional Visual Studio install if essentially all your work is directly in the database.

  • Daniel Parkinson

    SSC Veteran

    Points: 260

    I mostly use SSMS. I do like SSDT when creating a new database, and also try to use it to keep the deployed version of the DB linked to version control.

Viewing 15 posts - 1 through 15 (of 98 total)

You must be logged in to reply to this topic. Login to reply