How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio

Sergio Sanchez 0 Reputation points
2024-06-19T21:08:18.42+00:00

I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server

Azure Database Migration service
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 9,091 Reputation points Microsoft Employee
    2024-06-19T21:37:20.4266667+00:00

    Hi @Sergio Sanchez

    I'm assuming you want .bacpac file of a Azure SQL DB. Follow below steps.

    1. If you have SSMS installed in your machine, connect to database using ssms, use the server credentials or get access to take backup.
    2. Go to database, right click -> Task ->Export Data tier application
    3. Select storage account, container and file name, or you can export to your local and click next and then Export.
    4. User's image

    Once the file exported, you can import the same to another server

    Hope this help!

    Thank You!

    0 comments
  2. ZoeHui-MSFT 34,836 Reputation points
    2024-06-20T06:26:56.9766667+00:00

    Hi @Sergio Sanchez

    If you already have a database on local machine then you can migrate it directly on Azure using SQL Management Studio. Follow these steps:

    Right click on the database name in SSMS:

    User's image Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments