autocompletion (you start writing the first letters of SQL statement, and the editor completes it itself).
The SQL Code Editor with IntelliSense technologyĪzure Data Studio is developer oriented, and its main purpose is to write, edit and execute SQL queries, so of course it has a modern and advanced SQL Code Editor that supports IntelliSense technology, i.e. Let’s take a closer look at the functionality and features of Azure Data Studio. The distinctive feature of Azure Data Studio is that it allows you to visualize the results of SQL queries very easily, for example, to build charts and so on.Īs well as the results of SQL queries can be uploaded in one click to all popular data formats, such as Excel, XML, JSON or the same CSV. In addition, Azure Data Studio allows you to import CSV files, and even connect whole directories with scripts and data. This is what Azure Data Studio became.Īzure Data Studio allows you to work not only with Microsoft SQL Server databases, but also with SQL Azure database, and other DBMS, for example, almost out of the box supports PostgreSQL. the ability to write and edit SQL instructions. All this was the reason to create a new cross-platform tool that would be simple, convenient and easy, developer-oriented and include only the most popular functionality, i.e.
Ms azure data studio install#
In addition, after Microsoft SQL Server became possible to install on Linux, it was necessary to provide developers with a tool that could be used on Linux, and as you know, SQL Server Management Studio is implemented only on Windows. At the same time, most of the functionality remains unclaimed in the vast majority of cases, as most developers only need functionality for writing SQL queries and developing procedures. Some might ask, “Why do you need this Azure Data Studio, because there is such a great tool as SQL Server Management Studio (SSMS)? And the fact that SSMS is a comprehensive solution for SQL Server developers and administrators, and it is quite heavy.
Overview of the functionality and features of Azure Data Studio
0 kommentar(er)
