In this blog post we will see how to restore database on windows azure sql database from a database copy. If the database copy is on the same server as the source database we can rename the copy to that of the source database. If the copy is on a different server we can simply point to the copy of the database url. Let us create a new server instance and rename the database later so that we could see both approaches.
Being SQL Database tab click on Servers at the top then click on Add
Fill out the login information and select your closet region. As you could see below we have successfully added a new server.
From the previous blog where we have created a backup blobs. Now we need to find the copy of the database that we need to restore and copy the url of .bacpac blob. We will be using that url in the next step to restore the database.
Now click on Databases option at the top then click on Import at the bottom of the portal.
In the next dialog paste the url you copied above in the bacpac url box. Change the new database name with a different name, select the server name that we created in the first step then enter your credential if you need you may click on the Configure Advanced Database Setting check box…
In the advanced dialog you may select 1 or 5 GB for web edition or click on business and select a larger database size.
We could see that our new database restored to the new server we created above.