How to migrate a SQL Server database to Azure portal (Azure SQL Database)?

Question

Hello All,

I have a Database available in SQL Server 2012 environment. I would like to migrate existing Database into the Azure Portal (Azure SQL Database).

Can anyone suggest me the steps or a good reference to continue?

Many Thanks to all of you.

Answer 1

You can use the free MS tool DMA = Data Migration Assistant, see Migrate your SQL Server database to Azure SQL Database using DMA

Download at Microsoft® Data Migration Assistant v4.1

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thanks. I will look into it and reply here my experience.

Answer 3

You need to use DMA (Database Migration Assistant) for the purpose

See details here

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

https://www.sqlshack.com/migrate-premise-sql-server-database-azure/

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page