如何在Mac OS X操作系统中连接远程SQL服务器?我真的不需要一个GUI,但它将是很好的颜色编码和结果集网格。我宁愿不用虚拟机。

是否有一个SQL客户端Mac OS X工作与MS SQL Server?


当前回答

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的替代品,我非常挑剔。

其他回答

我认为MySQL的Sequel Pro看起来很有趣。很难找到一种工具可以与所有这些数据库一起工作(特别是SQL Server 2005…大多数人使用SQL Server Management Studio,当然这只是Windows)。

让我们一起研究一个标准答案。

本地应用

SQLPro for MSSQL 纳维卡特 瓦伦蒂娜一室公寓 加桌

基于java的

Oracle SQL Developer(免费) SQuirrel SQL(免费,开源) 剃须刀SQL DB可视化工具 DBeaver(免费,开源) SQL Workbench/J(免费,开源) JetBrains DataGrip 元数据库(免费,开源) Netbeans(免费、开源、完整的开发环境)

电子

Visual Studio Code与mssql扩展 Azure Data Studio SQLectron

(待办事项:添加以下提到的其他事项)

尝试CoRD并直接从服务器修改您想要的内容。

它是开源的。

http://cord.sourceforge.net/

这将是我连续回答的第二个问题,所以我认为值得指出的是,我与这个产品没有任何关联,但我使用它并热爱它,并且认为它也是这个问题的正确答案:DbVisualizer。

这并没有明确地回答你的问题,因为我不确定Mac OS X中是否存在任何客户端,但我通常只是将远程桌面导入服务器并完成它。另一个选择是VMware Fusion(在我看来比Parallels好得多)+ Windows XP + SQL Server Management Studio。