HOW TO SETUP SQL ON MAC DRIVER
Where the Driver setting matches the name registered with unixODBC by the installation process, see odbcinst -q -d. # sqlcmd -S DockerMS -D -U user -P password You can configure DSNs in ~/.odbc.ini: # Give -D to connect using a DSN: How can I enable the SQL Server Browser service It seems to be a requirement in order for Data Cleaner to run correctly.
HOW TO SETUP SQL ON MAC INSTALL
$ ACCEPT_EULA=y brew install -no-sandbox msodbcsql mssql-toolsĬonnecting OS X host as a client to SQL Server running in Docker: $ sqlcmd -S 127.0.0.1 -U sa -P 'yourStrong(!)Password' Since I have a Macbook, I need to run SQL Server through Docker, so I dont have the usual components installed as regular SQL Server users. These are distributed as Homebrew packages: $ brew tap microsoft/mssql-release This should, in theory, support connecting with Windows Authentication if the Mac has Kerberos configured accordingly-something the sql-cli tool doesn't likely offer. Microsoft now provides OS X binaries of Command Line Tools for SQL Server, including sqlcmd, along with a first-party ODBC driver. If only I could use SQL Server that way! Short of implementing a command line client myself using straight JDBC, there anything out there that makes this possible? I like how MySQL can be used from the command line, so that seems like a great way to quickly get to my database and investigate a bug or add some test data. But it's still a huge pain to launch and quit, it eats up my RAM while it's running, and it poisons my Time Machine backups by altering several 2GB files on disk every time I use it.
I don't like any of the OS X GUI clients for SQL Server – I find them tedious and not very Mac-like – so for the time being I use SQL Server 2008 Management Studio, on Windows XP, via VMWare Fusion. I want a Unix command-line client for MS SQL Server. So our whole stack can be used from Mac and Windows natively … with the exception of our database, which is MS SQL Server (ranging from 2000 to 2008 depending on the application).
Our runtime is Java, our web server is Jetty, and our IDE is Eclipse.
0 kommentar(er)
