Computer hardware and software
What’s the best free SQL database management tool (for Microsoft SQL Server 2005) for Mac?
Question : What’s the best free SQL database management tool (for Microsoft SQL Server 2005) for Mac?
I’m using Microsoft SQL Server Management Studio Express on my PC, I’m hoping there is a similar free tool I can get for my Mac.
microsoft sql server
Best answer:
Answer by Greg B
theres a mySQL.. idk if its for mac though
By using a mac, you are going to lose all the functionality that is provided by the SSMS GUI. Can you still perform most of your job yes….( and btw, i prefer using my mac), however the GUI does provide some convenient features.
1. Solution is to manually code everything, painful, but good work experience, and run your commands through a jdbc connection. Since all DML, DDL is done using SQL this should not be a problem.
2. The solution I currently use is install Windows in a Sun Virtual Box Virtual machine, and install SQL Server Client Tools (SSMS there). This way I have been able to also experiment with the new SQL Server 2008 RC and use the superb features of the yet to be released GUI on a somewhat stable platform. You will obtain a lot of great features this route, including stuff like SQL Syntax Highlighting, Syntax Checking and also Intellisense Code completion for SQL and T-SQL Variables, etc