Fix the Browse SQL databases view (and PowerShell's Get-AzureResource) to return all databases
I have three SQL Azure databases on a server. After scaling up a couple of databases from S0 to S1, they each disappeared from the "SQL databases" section of portal.azure.com. The other database on the same server is still visible there. All three are still visible in the preview portal when I select "SQL servers" and click on the particular server, but when I try to drill down into one of the "hidden" databases from there, only the most basic information will populate. In particular, the Azure Resource Group shows as "Not Available".
This all happened about a week ago. I scaled-up one database first, and it disappeared from the preview portal, and then I scaled-up the second about a day later, and the same thing happened. The scale-up was done via manage.windowsazure.com; I don't know whether that makes a difference. I can still interact normally with all three databases in the old portal.
At the same time each database was hidden from the SQL databases view of the preview portal, it was also hidden from the PowerShell command Get-AzureResource, which is actually a bigger deal to me.
Sam apologies for the delay. Is this still happening to you? If so let me create a bug and get this resolved.
Damian Stanger commented
Nick, a Microsoft engineer was able to resolve this for me. He told me that the issue was caused by metadata being out of sync on the new portal, and he just refreshed it. To request help, you can create a Support Request via the new Azure portal. You'll have to select "Technical" as the Issue Type, and you'll need a Premier Support contract or Azure Program Benefits account.
Nick Jordan commented
I also have this issue. I upgraded an S0 instance to S1 from within the new portal several months ago and since then I have only been able to access the DB through the legacy portal.
Yes, Guy; the behavior has not changed. Feel free to email me if you need more information. Thanks for taking a look at this.