patternMinor
No data in Azure SQL after importing bacpac file
Viewed 0 times
afterfilesqlbacpacazureimportingdata
Problem
I've created a bacpac file of my database for transfer to Azure. The file is uploaded and imported successfully but there's no data in the imported database. What did I do wrong? There don't seem to be options about with or without data. The structure did end up correctly in the database.
I verified the bacpac by importing it locally.
I verified the bacpac by importing it locally.
Solution
TL;DR: It wasn't finished importing yet.
I found out - it was impatience. As soon as I could access the DB and see the structure I thought the import process was done. But it turned out it was still importing. So good to know that you can access it before it's ready. (In hindsight there was sort of an indicator, while it was still importing it showed 1 additional table, something with Transaction... bla).
However, I could have known as I found out that there would still be an 'Importing...' item in the Notifications panel in the Azure portal during the import. It doesn't show that on any of the blades however.
I found out - it was impatience. As soon as I could access the DB and see the structure I thought the import process was done. But it turned out it was still importing. So good to know that you can access it before it's ready. (In hindsight there was sort of an indicator, while it was still importing it showed 1 additional table, something with Transaction... bla).
However, I could have known as I found out that there would still be an 'Importing...' item in the Notifications panel in the Azure portal during the import. It doesn't show that on any of the blades however.
Context
StackExchange Database Administrators Q#156436, answer score: 5
Revisions (0)
No revisions yet.