如何在Mac OS X操作系统中连接远程SQL服务器?我真的不需要一个GUI,但它将是很好的颜色编码和结果集网格。我宁愿不用虚拟机。
是否有一个SQL客户端Mac OS X工作与MS SQL Server?
如何在Mac OS X操作系统中连接远程SQL服务器?我真的不需要一个GUI,但它将是很好的颜色编码和结果集网格。我宁愿不用虚拟机。
是否有一个SQL客户端Mac OS X工作与MS SQL Server?
当前回答
我在Windows操作系统上使用AquaFold,但它基于Java,支持Mac OS X。
其他回答
我一直在使用Oracle SQL Developer,因为微软的SQL Server软件目前还不能在Mac OS x上使用。我还推荐RazorSQL或SQLGrinder。
我也投票给RazorSQL。它在许多方面都非常强大,实际上支持大多数数据库。我主要用于SQL Server, MySQL和PostgreSQL。
Squirrel SQL是一个基于Java的SQL客户端,我在Windows和Linux上有很好的经验。因为它是Java,所以应该可以做到。
它是开源的。您可以同时使用多个数据库运行多个会话。
When this question was asked there were very few tools out there were worth much. I also ended up using Fusion and a Windows client. I have tried just about everything for MAC and Linux and never found anything worthwhile. That included dbvisualizer, squirrel (particularly bad, even though the windows haters in my office swear by it), the oracle SQL developer and a bunch of others. Nothing compared to DBArtizan on Windows as far as I was concerned and I was prepared to use it with Fusion or VirtualBox. I don't use the MS product because it is only limited to MS SQL.
底线是没有免费的东西是值得的,大多数商业非视窗产品也是如此
However, now (March 2010) I believe there are two serious contenders and worthwhile versions for the MAC and Linux which have a low cost associated with them. The first one is Aqua Data Studio which costs about $450 per user, which is a barely acceptable, but cheap compared to DBArtizan and others with similar functionality (but MS only). The other is RazorSQL which only costs $69 per user. Aqua data studio is good, but a resource hog and basically pretty sluggish and has non essential features such as the ER diagram tool, which is pretty bad at that. The Razor is lightning fast and is only a 16meg download and has everything an SQL developer needs including a TSQL editor.
所以最大的赢家是RazorSQL,只要69美元,就物有所值。相信我,在等待了几年之后,我终于找到了一个便宜的非窗口DBartizan的替代品,我非常挑剔。
基于java的Oracle SQL Developer有一个支持SQL Server的插件模块。我经常在我的Mac电脑上使用它。它也是免费的。
下面是如何安装SQL Server插件:
运行SQL Developer 进入这个菜单项:Oracle SQL Developer/Preferences/Database/Third-party JDBC Drivers 单击帮助。 它将有指向MySQL、SQL Server等JAR文件的指针。 SQL Server JAR文件可以在http://sourceforge.net/projects/jtds/files/上获得