Answered by:
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.
Friday, December 7, 2018 12:03 PM
Answers
-
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]- Edited by Olaf HelperMVP Friday, December 7, 2018 12:13 PM
- Marked as answer by Mangesh 8421 Friday, December 7, 2018 12:47 PM
Friday, December 7, 2018 12:13 PM -
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- Marked as answer by Mangesh 8421 Monday, December 10, 2018 12:57 PM
Friday, December 7, 2018 12:25 PM
All replies
-
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]- Edited by Olaf HelperMVP Friday, December 7, 2018 12:13 PM
- Marked as answer by Mangesh 8421 Friday, December 7, 2018 12:47 PM
Friday, December 7, 2018 12:13 PM -
Thanks. I will look into it and reply here my experience.Friday, December 7, 2018 12:15 PM
-
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- Marked as answer by Mangesh 8421 Monday, December 10, 2018 12:57 PM
Friday, December 7, 2018 12:25 PM