Having created an Azure SQL server resource, I'm now exporting a database from Management Studio 2014 to the Azure resource. It all seemed to be going well, but after going through all the tables, is now sitting on "enabling indexes" and has been for about 2 hours.
Deploy Database Screenshot
The database is relatively small, only 1.5GB mdf, with a 180MB log. I have also tried exporting from SSMS to a local .bacpac file, and that also ends up sitting there for over an hour after going through the tables, but before showing the "enabling indexes" item.
It seems like SSMS is having trouble with the database for some reason, however this is a backup from production and has been in use without issues for a long time.
I'm not sure what to look for at this point. Are there some tools to check the database for errors which I can use here, to see why SSMS isn't able to finish exporting the db?