search

Azure-Samples / sql-database-dotnet-manage-import-export-db

Getting started with importing and exporting SQL databases in C#
https://docs.microsoft.com/en-us/dotnet/azure
MIT License
6 stars 7 forks source link

No status checks #1

Open AdamMarciniec opened 5 years ago

AdamMarciniec commented 5 years ago

It is a nice example but things like importing a .bacpac take time, there should be checks before moving forward.

ionutmuresan commented 5 years ago

I have the exact same problem right now waiting for an import that is taking forever and which I cannot monitor in any way. Is there a way to at least cancel the import ? Not even deleting the database cancels the import, how is that even possible ? I need to be able to control these situations programmatically. There are also several different valid cases where the import fails but it throws the same generic error, that is not very helpful.

For me this is a great replacement for DacFx but these monitoring limitations are really annoying and can create serious issues in a production environment.

LE: A little update regarding the status check, you can use "Import/Export history" in the Azure portal to see the imports, unfortunately there isn't much more you can do in there neither, the imports that never completed are all displayed as "Running, Progress = 0% with no way of cancelling them", they fail by themselves eventually.