#Ms sql server on mac how to#
#Ms sql server on mac install#
#Ms sql server on mac pro#
#Ms sql server on mac free#
#Ms sql server on mac mac#

Given that my brand new Macbook Pro handles this without struggling itвЂ™s actually a fairly reasonable solution, but I cross my fingers that one day Oracle SQL Developer is completely compatible, or that someone makes a worthwhile GUI.

So unfortunately in the end I installed Windows XP (for itвЂ™s light weight), MS SQL Server and just use the native Microsoft SQL Management Studio. It also canвЂ™t handle multiple resultsets returned from a stored procedure, and wonвЂ™t handle the вЂњgoвЂќ command in SQL Server scripts. A common problem seems to be the BEGIN and END keywords.

#Ms sql server on mac how to#

It turns out that SQL Developer is fine with standard SQL like SELECT, INSERT, UPDATE, DELETE etc, but when running certain SQL Server specific commands, SQL Developer doesnвЂ™t know how to interpret it, or interprets it correctly. Running some stored procedures gave an error. It was all looking good until I ran into a problem. I got it all hooked up, everything was working well, I even connected over mmy SSH tunnels to remote clients (an article on that later). ItвЂ™s actually quite close to MicrosoftвЂ™s native client in feel. ItвЂ™s a completely professional, sexy, clean, efficient, enterprise grade, high end. I was about to lose hope then all of a sudden, another contender crossed my path: ItвЂ™s situations like this when you realise the word вЂenterpriseвЂ™ actually does have a meaning beyond just being a buzzword! The result set grids will have 10px padding so you can only see about 5 rows of result sets, or the result set grids cells donвЂ™t automatically resize to the width of the content within the cell (within reason) вЂ“ they just donвЂ™t cut it. There are real annoyances вЂ“ the forms are hideous. And after using them you immediately realise that these people either a) come from an old school linux or java background where everything is ugly and theyвЂ™re used to it, b) theyвЂ™ve never worked with large or complicated datasets where EFFICIENCY is of utmost importance and probably consider phpMyAdmin suitable for data wrangling.Д«ut the problem is theyвЂ™re not ok. ItвЂ™s funny you know, when you research this stuff, you see a lot of people recommending these products. When you get used to an environment like MS SQL Server, you just canвЂ™t revert back to this kind of rubbish. Most likely because theyвЂ™re Java based вЂ“ but theyвЂ™re just hideous. So I tried all these products, and hereвЂ™s the problem.

So after much reading & researching I narrowed my options down to a few potential candidates:

#Ms sql server on mac install#

One option of course was to install VMWare, install Windows, install Microsoft SQL Server and just use Microsofts native client. I needed the equivalent of Microsofts SQL Management Studio (which used to be called вЂњQuery AnalyzerвЂќ), or вЂњMySQL WorkbenchвЂњ. I have a seperate windows box with an SQL Server instance on it, and what I needed was a client program that could connect to the server so I could query it, write SQL, interrogate data etc. So basically I needed to use MS SQL Server.

#Ms sql server on mac mac#

LetвЂ™s not forget it was originally bought from Sybase (which is probably why the product isnвЂ™t all that bad! Microsoft didnвЂ™t create it!) Ssms On Mac It was FAR superior to the well known MySQL and a lot more affordable than Oracle. In fact not so long ago some may argue that it was one of the best choices for large systems. It is a decent product, itвЂ™s professionally supported, and most of the clients in my industry use it. Having said that I actually donвЂ™t mind the product OTHER than itвЂ™s requirement to be run on Windows. My work use it, personally I woudlnвЂ™t choose it for my own projects at all, IвЂ™d choose something less platform dependent. There was however a single piece of the puzzle that I knew I still had to deal with. Technologies such as Apache, PHP, ssh/shell, etc are almost more native to the *nix core than they are to windows. I knew that almost every element of my workspace would be easily transferrable to OSX, and in some cases more elegantly. I was very excited to get my environment set up as many friends who work in a similar field had sworn by it. Just last year I got my first Macbook Pro for development, after a lifetime of Windows (and linux/unix on server environments). For something that plays nice with MySQL on macOS or Windows, check out TeamSQL - TeamSQL is a cross-platform data client that works with multiple database environments, including PostgreSQL, Redis, Redshift, and MS SQL Server.

#Ms sql server on mac free#

DbVisualizer Free is a universal database tool that allows you to manage a wide range of databases including Oracle, Sybase, SQL Server, PostgreSQL, DB2, MySQL, Informix, H2, and SQLite.