I have followed the steps mentioned on this link and i have created new DB successfully on azure portal. However i would like to know how can i import that on existing database using .bacpac file?
2 Answers
2
votes
Currently the given answer won't work because as of now, the interface of the Azure portal has changed significantly. You won't find the import button that easily! Supposing that you have clicked SQL databases from the navigation panel, then at the bottom, click "New". Then you will find Import button. The rest is easy. It took me around 2 hours to figure out what Microsoft wrote in their documentation and what I am visualizing in their portal! It doesn't match and Microsoft forgot to update their documentations!
0
votes
If you want to import the bacpac file through the Windows Azure portal you'll need to go to SQL Databases and press the Import button. You will be able to choose a bacpac from one of your storage accounts (you can upload bacpac files to your storage account with a free tool like CloudXplorer).
Note: The import process does not allow you to import into an existing database. You'll get the option to create a new database.
