We will guide in an easy way with clearly defined steps to be followed in migrating On-premise SQL Server database to Azure SQL Database. Before going into details, it is must to have a good understanding of some of the terms:
|Azure SQL Database||
Create BACPAC files using Management Studio
Note: A BACPAC file will only be saved if you have no database compatibility issues. If there are compatibility issues, then the error message will be displayed on the console
In the process of migrating on-premises SQL Server database to Azure SQL Database, now we do the import of .bacpac file.
Importing the BACPAC file to Azure
Now that we have the BACPAC file ready, we can now use the same to migrate the data over to Azure. This BACPAC file could be stored locally, or on Azure Blob storage (standard)
For now, the Azure portal will allow you to only create a single database in Azure SQL Database, and this can be done only from a BACPAC file. Follow the steps below to import the BACPAC file you saved.