Get list of sql azure databases in a Windows Azure server

Question

Is there a simple way to code in c# to get the list of Sql Azure databases in a Windows Azure server?

Thanks Martin

Just in case you're interested, you can do this action from PowerShell fairly easily - I just documented how in this answer. — David Makogon
– David Makogon, Commented Jul 11, 2013 at 5:57

Ming Xu - MSFT · Accepted Answer · 2012-06-06 02:54:28Z

2

To list databases on a server, you can query the sys.databases table in the master database. You can use any data access framework you like to query this table, such as Entity Framework (http://msdn.microsoft.com/en-us/library/bb399572.aspx).

You can also list all servers under your subscription using the Management API (http://msdn.microsoft.com/en-us/library/windowsazure/gg715269).

answered Jun 6, 2012 at 2:54

Ming Xu - MSFT

2,1161 gold badge11 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Martin Over a year ago

Thanks. However the only tables that I see in the master database are sysdac_history_internal and sysdac_instances_internal. Am I looking in the right place?

Ming Xu - MSFT Over a year ago

Sorry, I meant sys.databases view (not table). Try "SELECT * FROM sys.databases" in SQL Server Management Studio. It should work. You can refer to msdn.microsoft.com/en-us/library/windowsazure/ff951625.aspx for more information.

Collectives™ on Stack Overflow

Get list of sql azure databases in a Windows Azure server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related