In this article we will look into how to deploy an On-premise Database To Azure DB in a step by step manner.
Introduction
In this article we will look into how to deploy an On-premise Database To Azure DB in a step by step manner.
Step by step approach
After creation of the Azure SQL DB Server as stated in the previous article(rnaazuretestdb)
let's open SSMS and connect to the local database
Right click on the database(e.g. ExperimentalDB) and select Tasks -> Deploy Database to Microsoft Azure SQL Database.
This will bring the Deploy Database to Windows Azure SQL Database wizard
Now let's go to the Deployment Settings section and provide the SQL Azure Server Connection.
The Deployment Settings section will now be
Click "Next" to proceed to the Summary page where we need to confirm the settings.
Finally click "Finish"
The database will now be exported to the Azure Portal.
Conclusion
In this article we saw how to deploy an On-premise Database To Azure DB in a step by step manner. Hope this will be helpful. Thanks for reading.