Using Azure SQL Services from a Mac?

views:

answers:

+1 Q:

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?

+2 A:

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.

JeffreyABecker 2010-07-19 19:18:09

Thanks, though I guess then my question is "is there a decent TDS client for the Mac?", short of DBI::Shell. I also assure you that I need a relational database :)

Erik Paulson 2010-07-20 19:18:41

You might want to look at http://stackoverflow.com/questions/3452/sql-client-for-mac-os-x-that-works-with-ms-sql-server.

JeffreyABecker 2010-07-21 18:18:47

I'd suggest you look at using oData:

http://www.odata.org/blog/2010/3/18/got-sql-azure-then-you've-got-odata

It's an RESTful protocol, and there is already an official objective-C SDK: http://www.odata.org/developers/odata-sdk

Doobi 2010-09-04 12:39:51

ansaurus

tags:

views:

answers:

Using Azure SQL Services from a Mac?

related questions