SQL Client for Mac OS X that works with MS SQL Server

 

How can I connect to a remote SQL server using Mac OS X? I don't really need a GUI, but it would be nice to have for the color coding and resultset grid. I'd rather not have to use a VM.

Is there a SQL client for Mac OS X that works with MS SQL Server?

Let's work together on a canonical answer.

Native Apps

  • SQLPro for MSSQL
  • Navicat
  • Valentina Studio
  • TablePlus

    • Java-Based

  • Oracle SQL Developer (free)
  • SQuirrel SQL (free, open source)
  • Razor SQL
  • DB Visualizer
  • DBeaver (free, open source)
  • SQL Workbench/J (free, open source)
  • JetBrains DataGrip
  • Metabase (free, open source)
  • Netbeans (free, open source, full development environment)

    • Electron-Based

  • Visual Studio Code with mssql extension
  • Microsoft SQL Operations Studio
  • SQLectron

    • (TODO: Add others mentioned below)

    The Java-based Oracle SQL Developer has a plugin module that supports SQL Server. I use it regularly on my Mac. It's free, too.

    Here's how to install the SQL Server plugin:

  • Run SQL Developer
  • go to this menu item: Oracle SQL Developer/Preferences/Database/Third-party JDBC Drivers
  • Click help.
  • It will have pointers to the JAR files for MySQL, SQL Server, etc.
  • The SQL Server JAR file is available at http://sourceforge.net/projects/jtds/files/

    • 这将是我已经回答的第二个问题，所以我认为值得指出的是，我没有与这个产品有任何关系，但我使用它并且喜欢它，并且认为它也是这个问题的正确答案： DBVisualizer中。

    链接地址: http://www.djcxy.com/p/44422.html

    上一篇: IIS7权限概述

    下一篇: 适用于Mac OS X的SQL Client，适用于MS SQL Server