O

9

11

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?

Olvan answered 19/7, 2010 at 18:28 Comment(0)

T

9

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.

Thing answered 26/5, 2014 at 19:6 Comment(4)

Which ODBC driver is used by SQLPro ? – Enneahedron 19/2, 2016 at 6:48

SQLPro uses FreeTDS. – Thing 19/2, 2016 at 14:50

Can you use FreeTds without having SQLPro under GPL license? – Enneahedron 22/2, 2016 at 0:58

FreeTDS is LGPL, which to my understanding can be used in commercial products as long as the proper terms are followed. There are many larger discussions about this (see programmers.stackexchange.com/questions/47323/… for an example). – Thing 22/2, 2016 at 10:52

M

5

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

Mean answered 8/6, 2017 at 6:45 Comment(1)

Actually it is one of the best free options to query MS SQL from Mac OS X. Installed seamlessly and working perfect – Cutworm 16/4, 2018 at 12:33

N

2

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.

Norvell answered 19/7, 2010 at 19:18 Comment(2)

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 :) – Olvan 20/7, 2010 at 19:18

You might want to look at #3952. – Norvell 21/7, 2010 at 18:18

F

1

I'm successfully using OpenLink's SQL Server Lite Driver v6.0 to connect to SQL Azure through Mac OS X Lion.

Folks answered 23/9, 2011 at 13:10 Comment(0)

T

1

Navicat Lite no longer exists

If you want something like Sequel Pro, I'd suggest Navicat Lite. It connects to my SQL Azure instances just fine, and the Lite version is free. It's a native OSX client, so there isn't any funky UI going on. The Lite version excludes some things like visual query building, but overall is very useful.

Tracheitis answered 21/10, 2011 at 4:14 Comment(1)

Is it just me or does Navicat Lite not exist anymore - just free trials of the various Navicat products? navicat.com/download – Excitant 24/12, 2014 at 19:38

F

1

@Erik Paulson, check out SQL-CLI, its a great command line tool to connect to Azure SQL Database and SQL Server natively on a Mac.

Foldboat answered 5/7, 2015 at 21:2 Comment(0)

F

1

DataGrip from JetBrains (makers of IntelliJ and PyCharm) is also a great option to query Azure SQL Database from a Mac.

Foldboat answered 27/10, 2015 at 17:36 Comment(1)

Note: I had to do this on Mac OS 10 Sierra to get DataGrip to connect (via JDBC): youtrack.jetbrains.com/issue/JRE-221#comment=27-1826316 – Tippler 17/9, 2017 at 22:46

Z

0

If you want a free option, and just need a commandline interface, you can install freetds. I found a great page on it here, it got me in and running without spending money.

https://martinrichards.tumblr.com/post/28488121620/connecting-to-sql-azure-using-freetds

I would note however, remeber you need to whitelist your PUBLIC IP on the Azure Console SQL server firewall (what you get when you google "what is my IP"). Remember that Azure is sitting out in the cloud, so you need to whitelist the IP it sees

Zincograph answered 5/4, 2018 at 17:55 Comment(0)

K

-1

I'd suggest you look at using oData.

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

Kerakerala answered 4/9, 2010 at 12:39 Comment(0)

Navicat Lite no longer exists

Recommended topics

Hot tags