other sql manger tools?

I like Database workbench a lot but it has (or used to have - not sure about
new versions) a big flaw. You cannot rename tables or many other objects. I
was told by support a year or more ago that you have to drop the object and
recrete it. I've stuck with EM for 2 reasons. The renaming issue and the
cost of db workbench. Just too much for me to deal with right now ($750 for
2 copies w/MS SQL module is a lot espeically when the other mods are so much
cheaper). I have 2 questions. Does the new version of db workbench allow you
to rename things? Are there other tools out there that are worth looking at
that are under $200 US? I reallly like the ability to edit or view blob type
data in db workbench, the code editor is lightyears ahead of EM and the fact
that the triggers are in the tree on the left is a big plus (never could
figure out why they are not shown in EM - sorta dumb). Oh and the test data
generator is a big plus as well (except that you can only add new rows with
it - it woudl be nice if you could add data to existing rows if new columns
have been added to a table - really surprised you can't do that).
Thanks,
Keith
have you used TOAD ?
Greg Jackson
PDX, Oregon
|||No. Never heard of it. I'll check it out. Thanks.
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:ujGN6rraFHA.1148@.tk2msftngp13.phx.gbl...
have you used TOAD ?
Greg Jackson
PDX, Oregon
|||http://www.toadsoft.com/toadsqlserve..._sqlserver.htm
free and pretty slick
GAJ
|||Thanks for the info Greg. I checked out TOAD and from what I could see it
seems too clunky and not much better than (and in some ways not as good as)
MS SQL EM. So I ended up getting a couple copies of DB Workbench by Upscene
after all. I like it very much. It's got a very nice and intuitive interface
and lots of cool features with more coming along soon. They're also very
willing to listen to suggestions for new features in upcoming releases. I
highly recommend it.
Keith