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.
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.
如果您想要 Sequel Pro 之类的东西，我建议您使用 Navicat Lite。它可以很好地连接到我的 SQL Azure 实例，并且 Lite 版本是免费的。它是一个原生 OSX 客户端，因此没有任何时髦的 UI。 Lite 版本排除了一些诸如可视化查询构建之类的东西，但总体来说非常有用。
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.
不过，我要注意的是，请记住，您需要在 Azure 控制台 SQL 服务器防火墙上将您的公共 IP 列入白名单（当您搜索“我的 IP 是什么”时会得到什么） ）。请记住，Azure 位于云中，因此您需要将其看到的 IP 列入白名单
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.
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
发布评论
评论（9）
您可能喜欢SQLPro for MSSQL（ Mac 应用商店）。
该应用程序具有一些巧妙的功能，例如：
免责声明：我是这个应用程序的开发者。我构建它是因为我想要一个无需运行 Windows 虚拟机即可访问 MSSQL 数据库的工具。我现在每天都使用这个工具，并不断为其添加更新和新功能。
You may like SQLPro for MSSQL (mac app store).
The app has a few neat features such as:
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.
使用带有 mssql 扩展的 Visual Studio Code 连接并查询 Azure SQL 数据库上的数据。
Use Visual Studio Code with mssql extension to connect and query data on Azure SQL database.
SQL Azure 提供标准 TDS 流，因此任何可以连接到本地 SQL Server 的程序都可以在给定正确的连接字符串的情况下进行连接。请参阅 http://www.connectionstrings.com/sql-azure。还要仔细考虑一下您是否需要完全关系数据库。如果您不这样做，Azure 表存储可能是一个不错的答案。
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.
我成功使用 OpenLink 的 SQL Server Lite Driver v6.0 通过 Mac OS X 连接到 SQL Azure狮子。
I'm successfully using OpenLink's SQL Server Lite Driver v6.0 to connect to SQL Azure through Mac OS X Lion.
@Erik Paulson，查看 SQL-CLI，它是一个很棒的连接命令行工具Mac 本机上的 Azure SQL 数据库和 SQL Server。
@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.
Navicat Lite 不再存在
如果您想要 Sequel Pro 之类的东西，我建议您使用 Navicat Lite。它可以很好地连接到我的 SQL Azure 实例，并且 Lite 版本是免费的。它是一个原生 OSX 客户端，因此没有任何时髦的 UI。 Lite 版本排除了一些诸如可视化查询构建之类的东西，但总体来说非常有用。
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.
JetBrains（IntelliJ 和 PyCharm 的制造商）的 DataGrip 也是查询 Azure SQL 数据库的绝佳选择一台Mac。
DataGrip from JetBrains (makers of IntelliJ and PyCharm) is also a great option to query Azure SQL Database from a Mac.
如果您想要一个免费选项，并且只需要一个命令行界面，您可以安装 freetds。我在这里找到了一个很棒的页面，它让我无需花钱即可运行。
https://martinrichards.tumblr.com/post/ 28488121620/connecting-to-sql-azure-using-freetds
不过，我要注意的是，请记住，您需要在 Azure 控制台 SQL 服务器防火墙上将您的公共 IP 列入白名单（当您搜索“我的 IP 是什么”时会得到什么） ）。请记住，Azure 位于云中，因此您需要将其看到的 IP 列入白名单
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
我建议您查看使用 oData。
它是一个RESTful协议，并且已经有一个官方的objective-C SDK：
http://www.odata.org/developers/odata-sdk
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