List all databases for a Azure SQL Server

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

List all databases for a Azure SQL Server

Post by structed » Wed 15 Nov 2017 16:27

When I connect to my Visual Studio LocalDB, I get all my databases listed.
However, if I connect to my Azure SQL Server, I it only shows master or the database I select.

How can I list all databases?

.jp
Devart Team
Posts: 326
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: List all databases for a Azure SQL Server

Post by .jp » Tue 21 Nov 2017 08:27

Hello,

Thanks for the post.
Could you please tell us what product you are using and its version.

Best Regards.

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Mon 11 Dec 2017 14:56

I am using dbForge Studio Express for SQL Server.

Update: Quite some time ago, we upgraded to Professional. Currently using the latest 5.7 release
Last edited by structed on Tue 02 Jul 2019 15:00, edited 1 time in total.

alexa
Devart Team
Posts: 2748
Joined: Fri 24 Jun 2011 14:17

Re: List all databases for a Azure SQL Server

Post by alexa » Tue 12 Dec 2017 10:27

Thank you for the reply.

We are planning to support this in one of the next product versions.

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Mon 16 Jul 2018 12:25

Is there any update on this feature? Currently using Studio Express 5.5.327. This is a major blocker for me now finally buying Professional

alexa
Devart Team
Posts: 2748
Joined: Fri 24 Jun 2011 14:17

Re: List all databases for a Azure SQL Server

Post by alexa » Mon 16 Jul 2018 14:58

It's in our roadmap for the next product versions. Unfortunately, we still have no an estimated date for this.

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Tue 24 Jul 2018 12:51

Is it on the Roadmap fro the next major or minor product versions? Because if I buy now, my company is not inclined to pay full again after my first year just because I need this feature...

alexa
Devart Team
Posts: 2748
Joined: Fri 24 Jun 2011 14:17

Re: List all databases for a Azure SQL Server

Post by alexa » Wed 01 Aug 2018 10:31

It should be fixed in the next minor version.

stas-lucky
Posts: 2
Joined: Fri 21 Sep 2018 09:04

Re: List all databases for a Azure SQL Server

Post by stas-lucky » Fri 21 Sep 2018 09:06

alexa wrote:
Wed 01 Aug 2018 10:31
It should be fixed in the next minor version.
Any updates on this? This really required feature

alexa
Devart Team
Posts: 2748
Joined: Fri 24 Jun 2011 14:17

Re: List all databases for a Azure SQL Server

Post by alexa » Thu 27 Sep 2018 12:03

This is to be done next year.

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Mon 26 Nov 2018 14:57

It's really a bummer. You support SQL Server 2019 but this super important feature to work with *any* SQL server database on Azure is not implemented yet.

Because of this, I currently have like 20 database connection entries in the database explorer to one single server. And we have multiple servers. Absolutely ridiculous...

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Tue 27 Nov 2018 08:41

Could you please at least remove the "Show all databases" checkbox for Azure SQL? To not let new users think they could do it...

alexa
Devart Team
Posts: 2748
Joined: Fri 24 Jun 2011 14:17

Re: List all databases for a Azure SQL Server

Post by alexa » Mon 03 Dec 2018 09:49

Thank you for bringing this to our attention.

We will take this into account.

structed
Posts: 11
Joined: Tue 07 Nov 2017 10:07

Re: List all databases for a Azure SQL Server

Post by structed » Thu 16 May 2019 14:57

We're now almost halfway into 2019.. Do you have a more concrete plan now as to when this is being implemented?

Caopi
Posts: 1
Joined: Thu 16 May 2019 14:56

Re: List all databases for a Azure SQL Server

Post by Caopi » Thu 16 May 2019 15:03

This is really an absolutely essential feature and I'm also waiting for this.

Post Reply