News for hackers. Stuff that matters.
Re:PostgreSQL vs. MS SQL Server by MagicWishMonkey on Thursday April 30, 2015 @09:15AM (#9464824)
The closest thing to SQL Server Management Studio I've found is Navicat. It's not as solid as Management Studio, and it's incredibly expensive, but it is much better than most of the other tools out there.

If you can expense the cost of the license you should definitely check it out.

Re:PostgreSQL vs. MS SQL Server by _JamesA_ on Thursday April 30, 2015 @10:20AM (#9465198)
I have found DbVisualizer [1] to be a superior tool and it supports almost every database in existence, Postgres and SQL Server included.

Plus it's completely cross-platform and runs on Linux, Windows and OS X.

[1]: http://www.dbvis.com

Re:PostgreSQL vs. MS SQL Server by MagicWishMonkey on Thursday April 30, 2015 @10:42AM (#9465335)
That's pretty slick, and it's much more competetively priced than Navicat.
Re:PostgreSQL vs. MS SQL Server by sleepyhead on Thursday April 30, 2015 @09:25AM (#9464871)
If you are on Mac check out https://eggerapps.at/postico/
Re:PostgreSQL vs. MS SQL Server by MagicWishMonkey on Thursday April 30, 2015 @09:49AM (#9465002)
This looks pretty nice, thanks!
Re:PostgreSQL vs. MS SQL Server by dphase on Thursday April 30, 2015 @11:22AM (#9465605)
I've been a fan of Aqua Data Studio for years and it doesn't seem to get mentioned often. Cross platform and supports a myriad of dbs. http://www.aquafold.com/aquadatastudio.html
Re:PostgreSQL vs. MS SQL Server by kidmenot on Thursday April 30, 2015 @09:43AM (#9464972)
Agreed on Navicat. pgAdmin doesn't quite cut it just yet.

Which sometimes made me wonder if, with Postgres becoming more popular by the day, there would be a market for a management tool cheaper than Navicat.

Re:PostgreSQL vs. MS SQL Server by msl09 on Thursday April 30, 2015 @09:57AM (#9465045)
Postgresql have such an amazing documentation and CLI that I prefer to use it over pgAdmin.
Re:PostgreSQL vs. MS SQL Server by toolz on Thursday April 30, 2015 @10:55AM (#9465430)
This is why I prefer postgres. Jumping into the CLI is easy and much quicker than mousing around some clustered up feature overloaded GUI.
Re:PostgreSQL vs. MS SQL Server by mmgutz on Thursday April 30, 2015 @10:25AM (#9465227)
Last I tried Navicat it didn't offer much over pgAdmin. The UI was more streamlined but that wasn't reason enough to switch to it. What features in navicat are must have and not found in pgAdmin3?
Re:PostgreSQL vs. MS SQL Server by danneu on Thursday April 30, 2015 @11:25AM (#9465629)
I use both Navicat and pgAdmin3 these days.

One thing I like about pgAdmin3 is the ability to only execute the query you have highlighted and also the scratchpad. It's nice for exploratory querying. In Navicat, I like switching between various tabs where pgAdmin3 makes me switch between windows.

Both have some hilarious idiosyncrasies. When one locks up for no reason, I generally just alt-tab to the other.

Recently I was using pgAdmin3 and set my production database color to red. I happened to notice that the color didn't repaint back to green when I switched to my dev database. And Navicat seems to consistently hang whenever the network dies or burps mid-action, requiring a command-line kill.

Idiosyncrasies. :)

Re:PostgreSQL vs. MS SQL Server by ironchef on Thursday April 30, 2015 @03:28PM (#9467108)
AquaDataStudio was my choice at the time. Expensive, but worked on pretty much all the DBMS I had to use at the time (which included oracle, pg, teradata, mssql, mysql to name a few).
Re:PostgreSQL vs. MS SQL Server by edgarvm on Thursday April 30, 2015 @10:54AM (#9465420)
TOAD DBA Suite for SQL Server is nice too, very expensive though