SQL and VS Code

platypus

platypus

platypus

Caporegime
Joined
25 Jul 2003
Posts
40,420
Location
FR+UK
I'm a long time SSMS user but more out of necessity, and I really really want to ditch it. I'm using VSCode for almost everything else, and I want to try and move over to it full time for SQL. I've got a few handy plugins (code beautifier, debugger) but I'm struggling to replicate the Object Explorer. Using the MS SQL plugin I can set up connections, but it unless I'm doing something wrong, it seems to be on a per database level, rather than server, and as I work with many databases I don't really want to have to set up a new connection for every database. Is there a decent connection manager I'm yet to find?
 
I ditched SSMS a few years back and have been using Azure Data Studio instead. Despite the name, you can use it to connect to a DBMS hosted anywhere (some NoSQL/docDB implementations require extensions).

Annoyingly though, MS are dropping support for it and integrating it directly in to VSCode, so in theory if you're already using VSCode then you can just install the MSSQL extension and have access to ADS features within your IDE. More details on that here: https://learn.microsoft.com/en-us/azure-data-studio/whats-happening-azure-data-studio#migration-plan
 
Last edited:
Aye I read that the other day whilst on the hunt around, but that has the same problem as the lack of an Object Explorer.
 
I don't think object explorer is a plus. I recommend dapper and write your SQL in ssms. This is how we work and it's the standard in a number of large companies I've worked for.
 
For dev, sure. You need an object explorer when trying to optimise queries, or looking at execution plans, or doing security reviews etc.
 
You must log in or register to reply here.
Back
Top Bottom