![]() All that is not in SQL Operations Studio right now. In SSMS you have GUIs to manage users, generate a database scheme or add a column to a table. The thing that stands out most is that GUIs are missing. But if you’re used to the SQL Server Management Studio (SSMS) then you might miss a few things. What can’t it do today #Īgain, for me, the most important functionality is in there. There is a handful of extensions available right now, but this will probably expand over time. oĪlso, just like VS Code, there is support for extensions. What is also great is that IntelliSense is available when writing your queries. ![]() ![]() The data comes from queries that you write yourself so you can come up with any widget that you can think of. As shown in the screenshot underneath, you can easily access information on the top 5 slowest queries or the disk space used by certain tables. but you can’t manage those with anything other than queries.Īnother very useful thing you can already do is add Insight widgets. You can also access other things from the database like views, stored procedures, users, etc. From the grid, you are able to edit the data directly and there is also an SQL pane that you can pop open to write your own queries. You are able to connect to a server, or multiple servers for that matter and browse through the tables and rows. Also, it seems that is what the focus is on right now. Just connecting to the database and being able to query through my data and editing it was fine for me. But still, a desktop tool to do this is so much easier and faster. Something that is also available from within the portal in preview. I was instantly able to browse through my Azure database and even edit records from it. Just paste in the server name, username and password and hit Connect. SQL Operations Studio adding a new connectionĪlthough you can only choose a Microsoft SQL Server as a connection type, this can be used for Azure databases as well. Adding your first connection is pretty easy. What really stood out when first starting SQL Operations Studio is that it bears great resemblance with how Visual Studio Code looks. I imagine on other platforms it will be just as easy. Installation on Mac is pretty simple, just download the archive and place the resulting executable in your Applications folder. You can get it for Windows, Mac and Linux at this time. The SQL Operations Studio is an open-source tool which you can get from GitHub. From what I can see, at this point, the application is the same but Azure Data Studio will evolve from this point on.Īzure Data Studio upgrade notice Installing # Instead, you should download Azure Data Studio. When I just started SQL Operations Studio, it notified me that it will not receive future updates. In this blog, I will give you a quick glance. I have recently learned there is an alternative to this which works cross-platform for Windows, Linux and Mac OS and it’s called SQL Operations Studio. There is one tool that I was missing though, the SQL Server Management Studio. This works very well because of tools like Visual Studio for Mac and Visual Studio Code. And frankly, I try to make a challenge out of it to not leave Mac OS for other development work as well. My main development work happens on a Mac using Mac OS because I develop apps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |