SSMS or SSDT

Question

SSMS or SSDT

Viewing 15 posts - 31 through 45 (of 97 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Since I'm old school I do prefer working in SSMS, but am working to get all our databases into SSDT Database projects to get them into TFS. I'm essentially trying to advocate for the distributed development model at my shop where we'd do the actual database development locally, then put the changes into the database project and check them into TFS, then have a build out to our development integration server. Not there yet.

The tie into SSMS is the one thing SQL Source Control has over SSDT database projects.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

mpereira@pollardwindows.com SSC Enthusiast Points: 169 More actions · Answer 2

mpereira@pollardwindows.com

SSC Enthusiast

Points: 169

March 27, 2015 at 7:02 am

#1786860

SSMS exclusively

Russ1of5 Mr or Mrs. 500 Points: 510 More actions · Answer 3

SSMS about 95% of the time. I find it easier to use. I wish that SSDT was more similar to SSMS because it makes sense to use it there since I almost always have to have both SSMS and Visual studio open.

TerryS SSCommitted Points: 1756 More actions · Answer 4

TerryS

SSCommitted

Points: 1756

March 27, 2015 at 7:11 am

#1786862

SSMS for the win.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

Jack Corbett (3/27/2015)
Since I'm old school I do prefer working in SSMS, but am working to get all our databases into SSDT Database projects to get them into TFS. I'm essentially trying to advocate for the distributed development model at my shop where we'd do the actual database development locally, then put the changes into the database project and check them into TFS, then have a build out to our development integration server. Not there yet.
The tie into SSMS is the one thing SQL Source Control has over SSDT database projects.

This is the way to go, good luck.

SQL Source Control is made redundant by SSDT, in my opinion.

(Now that's not going to please the forum owners :-))

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Rafal Tynski Grasshopper Points: 24 More actions · Answer 6

Rafal Tynski

Grasshopper

Points: 24

March 27, 2015 at 7:27 am

#1786870

I use

SSMS 🙂

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 7

Steve-3_5_7_9

SSChampion

Points: 10832

March 27, 2015 at 7:27 am

#1786871

SSMS

Jim_K SSCrazy Points: 2418 More actions · Answer 8

Both!

SSMS -- Day to day scripting and tasks. Need a backup before a change? Need to prototype something in test real quick? SSMS.

SSDT (in Visual Studio) -- Develop the schema and have everything in a nice package + deployment. Saves me a lot of time. Yeah I could do this in SSMS, but I started using SSDT and never went back.

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 9

I like Visual Studio a lot, and use it (VS 2012) for SSIS work, but I use SSMS for my SQL development work, primarily because I'm used to it.

Chris Wooding SSCarpal Tunnel Points: 4555 More actions · Answer 10

Both! We use SSMS for developing/testing. When a project is ready to go into UAT, the changes from development are put into the project in Visual Studio so that they can be checked into TFS and an implementation script is generated from the Visual Studio project.

hakim.ali SSCarpal Tunnel Points: 4239 More actions · Answer 11

We are a Microsoft shop, and our developers live in Visual Studio. They also do a lot of DB development. This happens in Visual Studio SSDT. We tie it to TFS for source control and also use it for automated deployments. Prod DBAs heavily use SSMS for administration and management. Us Dev DBAs live in both tools/worlds. I'm a big fan SSMS.

As an aside, now SSMS really is a Visual Studio IDE/extension/development/tool/thingy, so if you work in SSMS you are indirectly working in Visual Studio.

Hakim Ali
www.sqlzen.com

misaac Newbie Points: 1 More actions · Answer 12

I am new to SSRS. The way our system is configured I have SSMS but can not connect to the db. I am actually extracting data from an oracle db via SSRS. I use SSDT when developing SSRS reports.

Peter Schott SSCrazy Eights Points: 9675 More actions · Answer 13

SSMS - main tool as I do a lot of ad-hoc queries

SSDT - main dev tool. Everything that we push to our servers has to be in an SQL Project or it doesn't go. Our devs have been doing local development for some time and having the ability to quickly update their local DBs from source control is part of being successful for that.

(We did use SQL Data Compare to get a scaled down data set for testing from our shared/dev server.)

In regards to SSDT vs. SQL Source Control - they're both good, if slightly different in their approaches. SQL Source Control at least attempted to write to SSDT Projects at one point, but I don't know how far that went. I'll admit to leaning more towards SSDT, but I'd use either over most of the competing ideas.

Edit:

I've written up our experiences/process for SSDT here if anyone is interested: http://schottsql.blogspot.com/2013/10/all-ssdt-articles.html

I'd also highly recommend Jamie Thomson's posts on SSDT and related here: http://sqlblog.com/blogs/jamie_thomson/archive/tags/SSDT/default.aspx

Ken SSCoach Points: 17191 More actions · Answer 14

SSMS. I only use SSDT for SSIS and SSAS. I tried doing DB work in SSDT a few times but found it to be too clunky.

EMS9Tech SSC Veteran Points: 275 More actions · Answer 15

Ditto to shillbot: "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"