如何在Mac OS X操作系统中连接远程SQL服务器?我真的不需要一个GUI,但它将是很好的颜色编码和结果集网格。我宁愿不用虚拟机。
是否有一个SQL客户端Mac OS X工作与MS SQL Server?
如何在Mac OS X操作系统中连接远程SQL服务器?我真的不需要一个GUI,但它将是很好的颜色编码和结果集网格。我宁愿不用虚拟机。
是否有一个SQL客户端Mac OS X工作与MS SQL Server?
当前回答
如果您还没有它,它可能不是最好的解决方案,但是FileMaker 11与实际的SQL Server ODBC驱动程序(http://www.actualtech.com/product_sqlserver.php)在我今天的一个客户端上运行得很好。ODBC驱动程序只要29美元,但FileMaker要299美元,这就是为什么只有在已经拥有它的情况下才考虑使用它的原因。
其他回答
我使用Eclipse的数据库开发插件——像所有基于Java的SQL编辑器一样,它可以与任何类型4(即纯Java) JDBC驱动程序跨平台工作。对于基本的事情来说,它是可以的(主要的失败是它很难给予事务控制——auto-commit=true似乎总是设置)。
微软有一个不错的JDBC type 4驱动程序:http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en它可以用于Win/Mac/Lin/etc上的所有Java客户端/程序。
那些在Mac上挣扎于Java/JDBC的人大概是在尝试使用本机驱动程序而不是JDBC驱动程序——我已经将近10年没有使用过(或者实际上听说过)ODBC驱动程序桥了。
对于MySQL,有Querious和Sequel Pro。前者售价25美元,后者是免费的。你可以在这里找到它们的比较,以及一些其他Mac OS X MySQL客户端的列表。
史蒂夫
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的替代品,我非常挑剔。
我也投票给RazorSQL。它在许多方面都非常强大,实际上支持大多数数据库。我主要用于SQL Server, MySQL和PostgreSQL。
当问到这个问题时,微软OS X的远程桌面已经不受支持很多年了。它不是通用二进制文件,而且我发现它有点bug(我记得应用程序在连接失败后会退出,而不允许您更改连接信息并再次尝试)。
当时我推荐了Open Source CoRD,这是一个很好的Mac RDP客户端。
此后,微软Mac 2远程桌面客户端发布。