AWS/Azure/OpenShift Oracle/MSSQL/MySQL Windows Windows Server

How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer

image-10

Microsoft SQL Server Management Studio (SSMS) is an integrated environment where you can manage your SQL infrastructure. SSMS can be used to access, configure, manage, administer, and develop all components of SQL Server and Azure SQL Database. Microsoft SQL server management studio is a free software for public use and can be connected to any of your SQL server instances. MsSQL is a collection of tables that stores structured data in the form that contains a collection of rows that is referred to as records and columns that is referred to as attributes. Here are some similar guides you can read: How to install Microsoft SQL Server Management Studio, How to uninstall Microsoft SQL Server Management Studio, How to download and install Microsoft SQL Server 2019 Express Edition and Microsoft Management Studio on Windows Server, How to uninstall Microsoft SQL Server on Windows 10 and Windows Server

In this guide I will show you how to quickly export and import your database from Azure account to your local computer.

  • Login to your Azure Portal: https://portal.azure.com
  • Under Azure Services click SQL databases and select the Database you want to access.
image
Open your MsSQL Database on Azure
  • Click Set server firewall and add your system IP to the firewall rule and Save.
image-1
Setting your Firewall rule on Azure
  • Download SSMS and install on your local system.
  • Copy the Server name and login name from the Azure portal and enter the valid password and connect to your Azure database.
image-2
Microsoft SQL Server Management Studio

Exporting Database

  • After you have connected right-click database. Click Tasks > Export Data-tier Application.
image-3
Exporting Database
  • Select Save to local disk and browse to the location you want to export the data.
image-4
Export Setting
  • Click on Next and you start exporting
image-5
Exporting Database

Importing Database

  • After you have connected right-click database and select Import Data-tier Application.
image-6
Importing Database
  • Select Import from local disk and browse to the location you have the database file you want to import.
image-7
Import Settings
  • Make sure you give the database a name, enter the edition, maximum database size and service objective.
image-8
Database settings
  • Importing of Database starts.
image-9
Importing Database

I hope you found this blog post on How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer very interesting and helpful. In case you have any questions do not hesitate to ask in the comment section.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x