Azure Data Studio: Features, Comparison, Backup, and Restore

Comparison Between Azure Data Studio And SSMS

Use ADS If You :

• Need the ability to quickly chart and visualize result sets.
• Can execute most administrative tasks via the integrated terminal using sqlcmd or PowerShell.
• Have a minimal need for wizard experiences.
• Don’t need to do deep administrative or platform-related configuration.
• Need to run on macOS or Linux.

Use SSMS If You :

• Need to make use of performance tuning advisors and dashboards.
• Use database diagrams and table designers.
• Need access to Registered Servers.
• Make use of live query stats or client statistics.

Code Snippets

Code snippets in Azure Data Studio are templates that make it easy to create databases and database objects. Azure Data Studio provides several T-SQL snippets to assist you with quickly generating the proper syntax. User-defined code snippets can also be created.

Scope Of Settings

• User – These settings apply globally to any instance of ADS you open.
• Workspace – Workspace settings are settings specific to a folder on your system, and are only available when the folder is open in the Explorer sidebar. Settings defined on this scope override the user scope.

File Locations

Depending on what platform you use

• Windows %APPDATA%\azuredatastudio\User\settings.json
• Mac $HOME/Library/Application Support/azuredatastudio/User/settings.json
• Linux $HOME/.config/azuredatastudio/User/settings.json

Preview Feature In ADS

1.) On First Launch

If you’re a new user, you can select preview features when you launch ADS for the first time. On startup, a notification will appear in the bottom-right corner of the screen that gives you the option to enable or disable preview features. Select Yes (recommended) to enable preview features.

Use ADS To Connect And Query SQL Server

1. Start Azure Data Studio.

2. The first time you run Azure Data Studio the Welcome page should open. If you don’t see the Welcome page, select Help > Welcome. Select New Connection to open the Connection pane.

3. This article uses SQL Login, but Windows Authentication is supported. Fill in the fields as follows:

• Server Name: Enter server name here. For example, localhost.
• Authentication Type: SQL Login
• User name: the user name for the SQL Server
• Password: Password for the SQL Server
• Database Name: <Default>
• Server Group: <Default>

4. Then create a database.

5. Right-click on your server, localhost, and select New Query. Paste the below code into the query window and then select Run.

USE master
GO
IF NOT EXISTS (
 SELECT name
 FROM sys.databases
 WHERE name = N'TutorialDB'
)
 CREATE DATABASE [TutorialDB];
GO
IF SERVERPROPERTY('ProductVersion') > '12'
 ALTER DATABASE [TutorialDB] SET QUERY_STORE=ON;
GO

6. Create a table if The query editor is still connected to the master database, but we want to create a table in the TutorialDB database that we have created. Then Change the connection context to TutorialDB.

7. To view the data returned by a query Paste the below code into the query window and click Run.

Backup And Restore Database Using ADS

a.) Backup

1. Open the TutorialDB database dashboard by opening the SERVERS sidebar. Then select Ctrl+G, expand Databases, right-click your database, and select Manage.

2. Open the Backup database dialog box by selecting Backup on the Tasks widget.

3. This tutorial uses the default backup options, so select Backup.

b.) Restore

1. Open the SERVERS sidebar by pressing Ctrl+G. Then right-click your server, and select Manage.

2. Open the Restore database dialog box by selecting Restore on the Tasks widget.

3. Select the Backup file in the Restore from the box.

4. Select the ellipses (…) in the Backup file path box, and select the latest backup file for Database.

5. Enter your database name in the Target database box in the Destination section to restore the backup file to a new database. Then select Restore.

6. To view the status of the restore operation, select Ctrl+T to open the Task History.

Frequently Asked Questions

You Should Also Try

• Exam DP-300: Microsoft Azure Database Administrator Associate
• Microsoft Certified Azure Database Administrator Associate(Hands-On Labs)
• Azure SQL Deployment Options | SQL Managed Instance | SQL Database| SQL On VM
• Schedule And Automate SQL Server DB Replication

Next Task For You

We will cover all the exam objectives related to how to perform migrations, Hands-On Labs, and practice tests in our Azure Database Administrator training program. If you want to begin your journey towards becoming a Microsoft Certified: Azure Database Administrator Associate by checking our FREE CLASS.