Azure Data Studio vs SSMS - Who is the winner?

Question

Azure Data Studio vs SSMS - Who is the winner?

Daniel Calbimonte

SSCertifiable

Points: 6200
More actions
November 10, 2021 at 12:00 am

#3948012

Comments posted to this topic are about the item Azure Data Studio vs SSMS - Who is the winner?

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

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

PatrickSimons Right there with Babe Points: 724 More actions · Answer 1

BTW. you forgot a very important feature for developers: debugging stored procedures. SSMS 17 still can it, SSMS 18 not - ADS? That feature is more important than the other items you pointed out.

Patrick SIMONS, MCP

Skull Killer SSCrazy Points: 2504 More actions · Answer 2

Hi

SSMS also supports Source Control, as long as you install the right version of Visual Studio and Source control providers (at least for TFS/VSO). It's not Native, but works.

frederico_fonseca SSCoach Points: 16154 More actions · Answer 3

PatrickSimons wrote:

BTW. you forgot a very important feature for developers: debugging stored procedures. SSMS 17 still can it, SSMS 18 not - ADS? That feature is more important than the other items you pointed out.

hum. I have SSMS v18.5 and I can debug SP's just fine - if you can't then there may be other settings preventing you from doing it but not SSMS on its own.

frederico_fonseca SSCoach Points: 16154 More actions · Answer 4

Schema compare - same way that ADS requires an add-on to do it, SSMS also has a free add-on (from devart) that can be installed to do it - so from my point of view they are side by side on this one.

and as mentioned above it also allows source control (both free and paid add ins)

PatrickSimons Right there with Babe Points: 724 More actions · Answer 5

Could you please share a screenshot how you debug SPs?

AFAIK you can only use Visual Studio to debug SPs, not SSMS 18....

See also:

https://stackoverflow.com/questions/56565764/how-do-you-debug-or-step-through-the-code-in-sql-server-management-studio-18

Patrick SIMONS, MCP

dmbaker SSCertifiable Points: 5139 More actions · Answer 6

Tear-away, separate windows: SSMS 10000, ADS 0. Yeah sure, I can open up another instance of ADS, but no.

TIMA-225577 Valued Member Points: 52 More actions · Answer 7

Where to find SSMS v18.5?

I have, and can only find, up to v18.1.

PatrickSimons Right there with Babe Points: 724 More actions · Answer 8

current version is 18.10.

see: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Patrick SIMONS, MCP

frederico_fonseca SSCoach Points: 16154 More actions · Answer 9

standard way of debugging.

window with exec... and hit F11

debug_sp_ssms_18.5

This reply was modified 3 years ago by frederico_fonseca.

TIMA-225577 Valued Member Points: 52 More actions · Answer 10

Interesting.

2021-11-10_9-12-44

Guess need to ask where to get Frederico's version that can still debug stored procedures?

TIMA-225577 Valued Member Points: 52 More actions · Answer 11

TIMA-225577

Valued Member

Points: 52

November 10, 2021 at 2:18 pm

#3949921

Never mind, found it.

frederico_fonseca SSCoach Points: 16154 More actions · Answer 12

and when you try debugging what error do you get? unless for some reason your 18.10 does not have the debug menu at all.

TIMA-225577 Valued Member Points: 52 More actions · Answer 13

No error message, no debug menu, nothing happens when you do F11.

I too had come across that stackoverflow site a few weeks back and thought debugging was a feature up to v17.

So I was surprised to see a v18 release that still included it.

TIMA-225577 Valued Member Points: 52 More actions · Answer 14

And, I would use ADS more often if I could use the import option for more than just flat files.

Or am I missing something?

Can it be configured to call the SQL Server Import/Export Wizard like SSMS?

For this reason, SSMS is still the "winner" for me.

This reply was modified 3 years ago by TIMA-225577.