{"id":327,"date":"2013-08-16T13:17:57","date_gmt":"2013-08-16T18:17:57","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=327"},"modified":"2014-03-07T13:34:42","modified_gmt":"2014-03-07T19:34:42","slug":"move-an-on-premise-sql-server-database-to-the-sql-azure-cloud","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/move-an-on-premise-sql-server-database-to-the-sql-azure-cloud\/","title":{"rendered":"Move an On Premise SQL Server Database to the SQL Azure Cloud"},"content":{"rendered":"

Most of us have heard of SQL Azure, but a lot of people have yet to adopt the “cloud” version of SQL Server. This post will focus on how to move an on premise database to the SQL Azure and Windows Azure VM. To learn how to get started with SQL Azure visit Microsoft’s Azure site.<\/p>\n

Most of us are used to the “Restore Database” command found by right clicking the Databases container in SQL Server Management Studio (SSMS). SQL Azure has done away with this and instead only gives you the options below:<\/p>\n\n\n\n\n
On premise database<\/span><\/td>\nAzure database<\/span><\/td>\n<\/tr>\n
\n\n
\n

\"SQL<\/a><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This isn’t very helpful and can make you want to deactivate your Azure subscription immediately, but hold on…there is a way.<\/p>\n

First, you will need to create a storage account from Windows Azure. To do this, log in to Azure and click Storage, New from the left pane:<\/p>\n

\"SQL<\/a>
\nClick Quick Create, Enter a URL and Location, and click Create Storage Account:<\/p>\n

\"SQL<\/a><\/p>\n

Once the storage is created you should be able to view and manage it by clicking on the storage item on the left pane.<\/p>\n

Click Manage Access Keys and take note of the Storage Account Name and Primary Access Key:<\/p>\n

\"SQL<\/a>\"SQL<\/a>
\nNext click on the storage name and click Containers, Create a Container:
\n\"SQL<\/a>\"SQL<\/a>
\nBack in SSMS, right click on the database you want to move to the cloud and choose Tasks, Export Data-tier Application:<\/p>\n

\"SQL<\/a>
\nClick Save to Windows Azure and the Connect…button.<\/p>\n

\"SQL<\/a>
\nClick here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Most of us have heard of SQL Azure, but a lot of people have yet to adopt the “cloud” version of SQL Server. This post will focus on how to move an on premise database to the SQL Azure and Windows Azure VM. To learn how to get started with SQL Azure visit Microsoft’s Azure […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[76],"tags":[77,78],"class_list":["post-327","post","type-post","status-publish","format-standard","hentry","category-azure","tag-azure","tag-cloud"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":2,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/327\/revisions"}],"predecessor-version":[{"id":339,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/327\/revisions\/339"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}