Connect to Azure from Azure Data Studio. Generate an ER diagram.
- Download Azure Data Studio here
- What is Azure Data Studio? here
- Quickstart docs here
- Writing T-SQL docs here
Install Azure Data Studio in Ubuntu
Go to home and install the file (change to your exact file name)
cd ~ sudo dpkg -i ./Downloads/azuredatastudio-linux-1.40.2.deb
Selecting previously unselected package azuredatastudio. (Reading database ... 202924 files and directories currently installed.) Preparing to unpack .../azuredatastudio-linux-1.40.2.deb ... Unpacking azuredatastudio (1.40.2-1671747874) ... Setting up azuredatastudio (1.40.2-1671747874) ... Processing triggers for mailcap (3.70+nmu1ubuntu1) ... Processing triggers for gnome-menus (3.36.0-1ubuntu3) ... Processing triggers for desktop-file-utils (0.26-1ubuntu3) ... Processing triggers for shared-mime-info (2.1-2)
Activities and find
Azure Data Studio
Connect to a server
Create a connection to SQL Server.
Enter server name.
Select Active Directory authentication.
Enter an account. Create new. It opens a link to login with your AD account.
Generate ER diagram in Azure Data Studio
Extensions search for
Schema Visualization. Follow the steps to install.
Install opens the Github repo. Download the
VSIX file. In Data Studio, in the Extension. Go to the 3-dots menu, click
Install from VSIX, locate the file to install.
Create a database in Azure
Create a database in the Azure portal:
- Enter all basic details
Create a schema in Azure Data Studio
In Azure Data Studio:
- Go to Connections
- Expand server/databases
- Right click on the database
- New query
Instead of using the default
dbo schema, create your own. For example my schema is called
CREATE SCHEMA SchemaName; GO
Create a table in Azure Data Studio
For example create the tables
CREATE TABLE PL300.Product (