what's your choice of database editor?

What do you use out there for those day-to-day database editing/administration tasks?

Does it work for you?

What features are missing?

Who's rolled their own?

Winnol
Thursday, January 22, 2004

SQL Server 2k - Query Analyzer rules!

For long script editing, I use Jext (www.jext.org) as it is an advanced editor and supports t-sql syntax.

I wish Query Analyzer had a mode to encapsulate the last run statement in a complete transaction to roll back an accidental hit to the F5 key. Oh well, live and learn!

m
Thursday, January 22, 2004

I use a combination of all Enterprise Manager tools along with MS Access when working with SQL Server.  And a combo of Toad & MS Access when working with Oracle.

Worst DB tool of all time?  SQL Plus.

anon
Thursday, January 22, 2004

Obviously someone with a "free" database on *nix.

Crazy Larry
Thursday, January 22, 2004

Visual Foxpro for looking at anything, manipulating data.

Simon Lucy
Thursday, January 22, 2004

Visual Studio.NET 2003 does (almost) everything, right in the IDE.

The only thing "missing" is being able to assign permissions to stored procedures, etc. That would be useful, as then I wouldn't have to fire up Enterprise Manager, just to perform a few mouse clicks.

I know I could do "grant execute on sss to uuu", but I really don't like command-line interfaces any more.

Steve Jones (UK)
Thursday, January 22, 2004

TOra (www.globecom.se/tora)

TOAD (www.quest.com)

DB Visualizer (www.dbvis.com/products/dbvis)

Nobody
Thursday, January 22, 2004

I've rolled my own for MySQL at http://www.lazarusid.com/mysqlweb.shtml

It's not as feature rich as some of the MySQL tools out there, but it's better than the command line client, and it doesn't require me to install PHP. I whipped it up in an afternoon because installing PHP was going to be a real pain and take a lot longer.

Clay Dowling
Thursday, January 22, 2004

Embarcadero DBArtisan

Matt
Thursday, January 22, 2004

For Oracle I use TOAD

For PostgreSQL I use my own query tool/stored procedure editor.

Patrik
Thursday, January 22, 2004

The thing that annoys me about query analyser in sql server is the lack of "in place" editing. Alot of the time I just want to click on a field and make a minor correction.

Instead I have to type out an update statement.

It seems to me like one of those MS thngs where they've made something "good enough" and have no interest in improving it.

cf: IE.

Winnol
Thursday, January 22, 2004

Winnol -
1) You can do this in Enterprise Manger as well as in the VS.Net IDE

2) More to the point, by just "clicking and changing field names" you destroy any ability to maintain multiple databases (dev/test/production). All changes have to be scripted.

Philo

Philo
Thursday, January 22, 2004

phpMyAdmin for MySQL. Simple but nice enough.

Kraemer
Friday, January 23, 2004

  Recent Topics

  Fog Creek Home