Does anyone know when a tool will be available to manage a SQL Azure database from within Visual Studio or SQL Enterprise Manager?
+4
A:
At present one can only cannect via:
1) SQL Management Studio (SSMS) (The cancel and connect via new query method)
2) Azure Storage Manager: http://azurestoragemanager.codeplex.com/
3) SQL Azure Migration Wizard: http://sqlazuremw.codeplex.com/
4) Custom Application
I have gone down the custom route, an application that basically runs scripts within different folders to Update Tables and Stored Procesures etc.
Mark Redman
2009-10-16 19:46:28
SQL Server Management Studio 2008 R2 can connect to SQL Azure without the "cancel/new query method." However the tooling is still limited in functionality compared to SQL Server.
Chris Pietschmann
2010-09-23 14:32:02
A:
Plus:
- SQL Azure Explorer on Codeplex - free and with source code (addin for VS2010 Beta1)
- Cerebrata Cloud Storage Studio - Winforms app to browse SQL Azure
- Cerebrata Omega.MSSQL browser-based admin of SQL Server including SQL Azure (see announcement in blog post here)
Marc
marc_s
2009-10-16 21:21:14
A:
Few corrections below:
Cloud Storage Studio is for managing Windows Azure Storage (Tables, Blobs & Queues) and not SQL Azure.
Omega.MSSQL is for managing SQL Server (2008/2005/2000) via a browser based interface (IE only). We customized Omega.MSSQL to work against SQL Azure. That customized version is available online only. To read more about it and access the application please visit this link: http://cerebrata.com/Blog/post/Browser-based-SQL-Azure-Explorer.aspx
Thanks
Gaurav Mantri
Cerebrata Software
Gaurav Mantri
2009-10-17 05:01:59
A:
Haven't tried personally, but according to the SQL Azure team the November CTP of SQL Server 2008 R2 has a version of Management Studio that will allow direct connections to SQL Azure without having to do the cancel/connect workaround:
RichardI
2009-12-04 18:36:24