Using Azure SQL Services from a Mac? [closed]

Question

Azure SQL Services looks pretty cool, and I'd like to use it as a hosted database. I set myself up with a starter web edition database, and after clicking through a million and five EULAs, I got to a console and created a database. It gave me a connection string for ODBC, and for ADO.NET.

I'm using a Mac, with 10.6. What are my options?

Ideally, I'd find something like Sequel Pro or Querious that works with ODBC. Failing that, is there a web console or something?

I suppose there's always DBI::Shell in perl.

Is there anything better than installing Windows 7/VS2010 in VMWare?

Answer 1

You may like SQLPro for MSSQL (mac app store).

The app has a few neat features such as:

• Auto-completion and syntax highlighting.
• Azure database support (also supports federation).
• Tabbed based interface.
• Support for executing multiple queries at once.
• Quick access to tables, columns and more.
• Stored procedure execution.

Disclaimer: I'm the developer of this app. I built it because I wanted a tool for accessing MSSQL databases without running a windows virtual machine. I use this tool on a daily basis now and am continually adding updates and new features to it.

Answer 2

Use Visual Studio Code with mssql extension to connect and query data on Azure SQL database.

Answer 3

SQL Azure provides a standard TDS stream so any program which can connect to a local sql server could connect given the right connection string. See http://www.connectionstrings.com/sql-azure. Also take a good hard look at if you even need a fully relational database. If you dont, Azure Table Storage might be a good answer.