The Old Joel on Software Forum: Part 4 (of 5) - Sql server development tool?

Sql server development tool?

I started a new project where i take care of the sql server side. Can anyone recommend me a good develompent tool, like TOAD is for oracle?
I've tried query analyzer, omniview, mssqlexpress... and they all have some good features missing. Is there something good out there for sql server like there is for oracle?

martydud
Thursday, February 26, 2004

TOADsoft has a version of TOAD for SQL Server:
http://www.toadsoft.com/toadss.html

MR
Thursday, February 26, 2004

ah, that feels nice... but unfortunately it doesn't let me edit raw data, like images... it does have the select button on that column, but it doesn't do anything:/

martydud
Thursday, February 26, 2004

Check out DBArtisan from Embarcadero:

http://www.embarcadero.com

EMBT Employee
Thursday, February 26, 2004

"but unfortunately it doesn't let me edit raw data, like images... "

Uh, there's a reason for that... In general DBA's shouldn't be fiddling with data. If data routinely needs to be fiddled with, you put the appropriate fiddling interface into the appropriate application, or you automate the process.

Relying on a process step labeled "DBA fiddles with data" is a recipe for long-term grief.

I've done four years of heavy SQL work with just Enterprise Manager and Query Analyzer with occasional forays into Profiler. I'm not sure what else you would really need...

Philo

Philo
Thursday, February 26, 2004

I'm with you on that one Philo.

Some DBAs do seem to have a tendancy to tinker, for no apparent reason, although possibly to make themselves look busy. No reflection on the OP, just a general observation.

Steve Jones (UK)
Friday, February 27, 2004

I agree with Philo, despite the fact there are no disclaimers and he's outrageously biased in favour of MS ;)

Enterprise Manager is 95% all you need. There are occasions when I need to do something it won't do...but, hey. I'm a developer.

Justin
Friday, February 27, 2004

"Uh, there's a reason for that... In general DBA's shouldn't be fiddling with data. "

In general DBAs probably shouldn't do many things, but i was just wondering why most of the sql server development tools don't allow me to fiddle with binary data like images and blobs.

btw, thanks for that Embarcadero link, they had some nice products.

martydud
Friday, February 27, 2004

"I agree with Philo, despite the fact there are no disclaimers and he's outrageously biased in favour of MS"

Hey, I don't need a disclaimer when the original post already specifies the platform. I only disclaim when I'm recommending selection of a solution. :-P

But for the record, I am indeed a MS employee.

Philo

Philo
Friday, February 27, 2004

http://www.apexsql.com/sql_tools_edit.htm

see Apex SQL Edit a full SQL Editor / IDE

Randy
Wednesday, June 2, 2004