Nov 08 2022 05:55 AM
I've been working as a developer within SQL Server for over 15 years now (DWH and transactional) and think it's time I added SQL Azure to my toolbelt. I've created an account, server and database etc in Azure. Which tools are commonly used in organisations for doing the actual development? I've got Azure Data Studio installed which seems fairly straightforward if you're used to SSMS. Would Visual Studio be more commonly used and if so, would you install it locally and connect to your Azure account?
Also - when companies ask for experience in SQL Azure, do they merely want you to be able to create and develop databases using one the IDEs on Azure, which would mean an experienced SQL Developer like me should be able to get up to speed with SQL Azure in no time?
Duplicated post with New to Azure - which IDE tools? – SQLServerCentral Forums
Nov 08 2022 09:51 PM
@fuerteventura2023 , Azure Data Studio is a fine tool to manage SQL Azure databases (and some more RDBMS).
MS Visual Studio can be used together with the SSDT add-in to create database solutions, also for SQL Azure.
See
Download SQL Server Data Tools (SSDT) - SQL Server Data Tools (SSDT) | Microsoft Learn
Olaf
Nov 09 2022 08:02 AM
Nov 09 2022 09:57 PM
@CDBCons , SSMS has some limitation when connected to SQL Azure, better use Azure Data Tools.