Step by Step approach to deploy an On-premise Database To Azure DB

Rajnilari2015
Posted by in Azure category on for Beginner level | Points: 250 | Views : 584 red flag
Rating: 5 out of 5  
 1 vote(s)

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.

Page copy protected against web site content infringement by Copyscape

About the Author

Rajnilari2015
Full Name: Niladri Biswas (RNA Team)
Member Level: Platinum
Member Status: Member,Microsoft_MVP,MVP
Member Since: 3/17/2015 2:41:06 AM
Country: India
-- Thanks & Regards, RNA Team


Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)