Using Azure SQL Services from a Mac?
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
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.