The following instructions assume you already have a SQL Server database running somewhere that your Mac has network access to. Just FYI, Microsoft's instructions for installing the latest drivers are here.
SQLPro for MSSQL is the Premier application for editing and viewing SQL Server databases on mac os x. SQLPro for MSSQL. Download; Buy; A simple, powerful SQL Server manager for macOS Download Purchase (also available on the Mac App Store). Coming from Microsoft SQL Management Studio? Our interface and workflow is similar to what you are used. May 16, 2017 The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances of SQL Server. The utility is extremely useful for repetitive database tasks such as batch processing or unit testing. The bulk copy program utility (bcp). Oct 20, 2014 My Hard Drive went on my mac and after replacing it and reinstalling OS X 10.6.8 I cannot download Remote Desktop from the app store, it says I need at least OS X 10.7. I use to have Remote Desktop from the app store before I had to replace my hard drive. Does anyone know where I can download. Hi, Thank you for posting in Windows Server Forum. Jul 30, 2017 Another SQL Server GUI tool that you can use on your Mac (and Windows/Linux/Solaris) is DBeaver. DBeaver is a free, open source database management tool that can be used on most database management systems (such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby, and more).
- What is the best SQL client for Mac OS X? Update Cancel. A d b y D a t a d o g H Q. Improve MySQL performance quickly in Datadog. Easily identify slowing-running MySQL queries in seconds with Datadog. In Mac OS X is it possible to enter a URL into a file requester dialog?
- May 16, 2017 This post was authored by Meet Bhagdev, Program Manager, Microsoft We are delighted to share the production-ready release of the SQL Server Command Line Tools (sqlcmd and bcp) on macOS El Capitan and Sierra. The sqlcmd utility is a command-line tool that lets you submit T-SQL statements or batches to local and remote instances ofRead more.
Install FreeTDS and unixODBC
The connection to SQL Server will be made using the unixODBC driver manager and the FreeTDS driver. Installing them is most easily done using homebrew, the Mac package manager:
Edit the freetds.conf configuration file
Ensure the freetds.conf file is located in directory /usr/local/etc/, which will be a symlink to the actual file as installed by Homebrew. Check the specific location of the freetds.conf file by running tsql -C. The default file already contains a standard example configuration, but all you need to do is add your server information to the end, as follows:
There are other key/value pairs that can be added but this shouldn't usually be necessary, see here for details. The host parameter should be either the network name (or IP address) of the database server, or 'localhost' if SQL Server is running directly on your Mac (e.g. using Docker). A TDS version of 7.3 should be OK for SQL Server 2008 and newer, but bear in mind you might need a different value for older versions of SQL Server. For more information on TDS protocol versions see Choosing a TDS protocol version. Do not use TDS versions 8.0 or 9.0 though. Oddly, they are not newer than version 7.4. They are actually obsolete aliases for older TDS versions and their use is discouraged.
Test the connection using the tsql utility, e.g. tsql -S MYMSSQL -U myuser -P mypassword. If this works, you should see the following:
At this point you can run SQL queries, e.g. 'SELECT @@VERSION' but you'll need to enter 'GO' on a separate line to actually execute the query. Type exit to get out of the interactive session.
Edit the odbcinst.ini and odbc.ini configuration files
Run odbcinst -j to get the location of the odbcinst.ini and odbc.ini files (probably in the directory /usr/local/etc/). Edit odbcinst.ini to include the following:
Edit odbc.ini to include the following:
Note, the 'Driver' is the name of the entry in odbcinst.ini, and the 'Servername' is the name of the entry in freetds.conf (not a network name). There are other key/value pairs that can be included, see here for details.
Check that all is OK by running isql MYMSSQL myuser mypassword. You should see the following:
Microsoft office mac 2011 home and student requirements. Microsoft Office 2011 Home and Student Version for Mac BenefitsThe all-encompassing rewrite of Microsoft Office 2011 Home and Student Version for Mac includes a more user-friendly interface, making all the applications easier to use. Saving and sharing files is also quicker than it was in previous releases of Microsoft Office for the Mac.Older versions of Microsoft Office for the Mac did not have all the enhanced features and functionality offered in the Windows version of Microsoft Office.
You can enter SQL queries at this point if you like. Type quit to exit the interactive session.
Connect with pyodbc
It should now be possible to connect to your SQL Server database using pyodbc, for example:
Connecting without defining a DSN
Microsoft Sql Client Mac
If you don't want to define a DSN in odbc.ini, you can reference the driver entry you added to odbcinst.ini.
E.g.:
Note: in this case you may need to specify all necessary TDS parameters in pyodbc.connect.
Connecting without modifying odbcinst.ini or odbc.ini
If you want to avoid modifying both odbc.ini and odbcinst.ini, you can just specify the driver file location in the driver param in pyodbc.connect.
Microsoft Sql Client 12
E.g.: