How to Migrate Database to Azure

All of the markets now taking about azure and the new technologies in azure this means that all of us should learn what Is azure and what is the services related to our work in azure for example if you are SQL Server database administrator like Me, you should have fundamental information about azure services, and what is SQL Server types on azure and how we can manage azure SQL .

One of the most interesting topics for me How to migrate your SQL Server DB from on-premises to Azure, If you do search on google on this topic you will find many of articles talking about this subject, and based on my study I listed some notes that can help you on this subject

All of the information here depend on my study and search if something wrong I will be happy to correct me , and if there is extra information you know it related to this subject it will be great to share it on the comment for sharing the knowledge wit all of us I am highly recommend you to read the post first (https://www.thomasmaurer.ch/2019/01/azure-cloud-shell/)

Azure Data Migration tools

Below a list of all tools, you can use it on this project some of them can be acting the assessment tool and some of them acting the migration tool offline or online migration and some of them doing both jobs. The first 4 tools are the most commonly used.

Azure Data Migration Services (DMS):t is an Online migration using Azure DMS services it can be used to migrate multiple databases from multiple sources to multiple targets, DMS services used the DMA (Data Migration Assistant) services to generate assessment tool, and DMS services it can be used for automated migration for more information about how to use this services check this Microsoft video https://azure.microsoft.com/en-us/resources/videos/online-migrations-using-azure-dms/

Data Migration Assistant DMA: it is Microsoft tool used for assessment to check the compatibility, function and features that are not compatible with Azure even and the same tool used to migrate the DB from on-premises to Azure SQL Database, you can download it easily from this link https://www.microsoft.com/en-us/download/details.aspx?id=53595 and install it on your local PC or any on-premises server. For more information about the tool check, this post https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15 and for how to use it check this video

Data Migration Assistant | Data Exposed

Transactional Replication: SQL Server replication features can be used as services to migrate DB from on-premises to Azure SQL DB but SQL on Premises should be not less than SQL version 2012 SP2 CU8 and SQL on Premises will be acting the publisher and the Azure SQL DB will be acting as a subscriber it will support only push subscription it is the best option for short downtime and large database for more information check Microsoft Post (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-database-migrate#method-2-use-transactional-replication)
Export and Import BACPAC File using SSMS (Export data-tier application): For more information check this post-http://itproguru.com/expert/2015/03/how-to-move-or-migrate-sql-server-workload-to-azure-sql-database-cloud-services-or-azure-vm-all-version-of-sql-server-step-by-step/
SSDT SQL Server Data Tool
SQLPackage.exe: it is SQL CMD Package from Microsoft used for testing the compatibility issue and to migrate the DB from on-premises to Azure SQL Database with importing, exporting the BACPAC or DACPACk files
SQL Azure Migration Wizard SAMW: It is community support CodePlex with GUI interface used for testing the compatibility issue and to migrate the DB from on-premises to Azure SQL Database but this tool replaced now by DMA (Data Migration Assistant)

Migrating other databases to Azure Database:

If you target to migrate any other DB like Oracle, MongoDB, MySQL, DB2, PostgreSQL, Cassandra, MariaDB, access, SAP you should look into this site https://datamigration.microsoft.com/