ADS features

[tactiq-ben]

I suppose that since the announcement of the retirement of ADS, there will be a lot of features copied here.
Trying to work with vscode in MSSQL for one day, most requested feature would be the Manage tab you have in ADS that allows you to browse through (and filter) between server objects and script them to new queries.

[AlmostRemember]

I'm a heavy ADS user and I also tried out the MSSQL extension for a day. It's functional, but nowhere near as nice. I support the idea in general, but the extension has a long way to go. There are lots of little quality of life features in ADS to be replicated. It will be nice to have the full range of vscode extensions though. For example it's irritating that ADS doesn't have a bookmarks extension.

[thompp]

The ability to group servers based on what makes sense to me is a tremendous time saver to me. Especially with the support to group different types of database servers (MSSQL, MySQL, etc.). I've not found a similar feature yet in VS Code that works as well as this does in ADS.

[jmetape]

I'd like to see the query results split by editor group as in ADS. When you have sql queries in different editor groups, the query results show to the left in mssql extension:

In ADS the query results are split within their editor group:

SSMS is the same as ADS:

[joshbooker]

Missing Essential Features:

Database Object:

• Manage
• New Notebook
• New Database
• Delete
• Backup
• Restore
• Data-Tier Application
• Schema Compare
• Create Project from Database
• Update Project from Database
• Import Wizard
• Group By Schema
• Generate scripts
• Properties

Table Object:

• Edit data
• Design
• Rename
• Properties

[jjarrinf]

You did a very nice job around those missing features.

This features helped me to drive my teams to take control of their legacy database development and start using GIT, releases, and general DevOps Processes for something that many SQL Server Developers I know consider unpractical;

Data-Tier Application
Schema Compare
Create Project from Database
Update Project from Database
Import Wizard

Hope this features will be planned soon, but I understand there is a lot of coding to do in other areas.