AZURE SQL DATA IMPORT

Question

I want to move data from one azure sql database to new azure sql database. From the first one I have exported .bacpac file. I import it to the second one and I get

Import operation for <database_name> failed. ErrorCode: N/A ErrorMessage: Failure

What is wrong, I have tested different names, different admin users etc.

Please update your question with the commands you've tried and the error messages they generated. — user2320464, Jun 18 '18 at 15:23
@user2320464 I've made it using only import/export buttons on Azure Portal and that's all I know — Marek Szmalc, Jun 18 '18 at 17:56
Your question needs more detail. As is, it wouldn't surprise me if it was closed for being low quality or not answered at all. — user2320464, Jun 18 '18 at 20:04

score 0 · Answer 1 · answered Jun 19 '18 at 16:10

0

To get some more information on why this is failing can you follow the steps in this article to get some more detail. This should point us in the right direction to help you with a fix.

James

answered Jun 19 '18 at 16:10

James Donovan

146
2

score 0 · Answer 2 · answered Jun 19 '18 at 17:58

Please review and follow the instructions detailed here: Import a BACPAC file to a new Azure SQL Database

It is suggested that the .bacpac file be uploaded to Azure Storage to be sourced by the Azure SQL Database it is going to be imported.

Any errors or issues you encounter should be detailed here so as to identify and help you resolve them.

AZURE SQL DATA IMPORT

2 Answers2