What do you use?
I spend a good portion of my days hopping back and forth between SQL Server and Oracle. The built in Studio Management work just fine for me for SQL Server, but I find myself using TOAD for some tasks and PL/SQL Developer for others in Oracle.
This is a much greater debate than Chrome v. Firefox because my precious, precious productivity (aka TIME) is at stake. Looking forward to hearing about what I should really be using. Then again, maybe it's just a Google issue. If I'd just find out how to do the things I use one for in the other, then I could stick to one piece of software.
Then again, sometimes you need a paring knife and sometimes you need a cleaver. Or, in my own experience, sometimes you need buttercream and sometimes only fondant will work. I'll let you decide which is which.
I've come to be a fan of Oracle's SQL Developer, but I'm sure it's missing some features.
ReplyDeleteI also like Oracle's SQL Developer, but as I'm doing a lot of Java development lately I've been using IntelliJ Idea's Database Source Plugin more (which is really only great if you're doing Java stuff with some form of JDBC / hibernate / JPA connection). Otherwise it's adequate.
ReplyDeleteThen again, there are times that I prefer emacs as a PL/SQL editor (no really... I'm only half kidding).
It's been so long since I've used either of them, that I can't really comment. Back when I did, TOAD was clearly superior as a troubleshooting and adhoc query tool, and SQL Developer was better for code and development. But, it's clear that both products have evolved since then, so my opinion is pretty worthless.
ReplyDeleteSQL Developer is where I spend most of my time and TOAD for specific tasks. So then... I suppose it's business as usual =)
ReplyDelete