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

Other IDE tools

what are some other IDE tools to use with sql server 2000 and 2005? I like
query analyzer a lot and am not crazy about EM or SQL Workbench (or whatever
it is called these days).
What does this community use when you are not using QA, EM or Workbench? I
like to type in T-SQL rather than be using the GUI (but that doesn't mean I
want to use isql/osql :-)
I use QA almost exclusively, and will probably use SQL Server Management
Studio (formally known as SQL Workbench) in SQL Server 2005 exclusively.
I'm happy with both.
BG, SQL Server MVP
www.SolidQualityLearning.com
"Kyle Adams" <kadam@.aol.spammersbeware.com> wrote in message
news:udAs5PHjEHA.2556@.TK2MSFTNGP10.phx.gbl...
> what are some other IDE tools to use with sql server 2000 and 2005? I
like
> query analyzer a lot and am not crazy about EM or SQL Workbench (or
whatever
> it is called these days).
> What does this community use when you are not using QA, EM or Workbench?
I
> like to type in T-SQL rather than be using the GUI (but that doesn't mean
I
> want to use isql/osql :-)
>
>
|||I think Management Studio (the IDE formerly known as SQL WorkBench) is going
to turn out very useful, albeit missing features that some users are willing
to bypass upgrading for (e.g. open table). Here are some alternative
management tools you can investigate:
http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"Kyle Adams" <kadam@.aol.spammersbeware.com> wrote in message
news:udAs5PHjEHA.2556@.TK2MSFTNGP10.phx.gbl...
> what are some other IDE tools to use with sql server 2000 and 2005? I
like
> query analyzer a lot and am not crazy about EM or SQL Workbench (or
whatever
> it is called these days).
> What does this community use when you are not using QA, EM or Workbench?
I
> like to type in T-SQL rather than be using the GUI (but that doesn't mean
I
> want to use isql/osql :-)
>
>
|||Kyle Adams wrote:
> what are some other IDE tools to use with sql server 2000 and 2005?
> I like query analyzer a lot and am not crazy about EM or SQL
> Workbench (or whatever it is called these days).
> What does this community use when you are not using QA, EM or
> Workbench? I like to type in T-SQL rather than be using the GUI (but
> that doesn't mean I want to use isql/osql :-)
Imceda Software makes a really nice IDE tool (www.imceda.com)
David G.
|||Hi Kyle,

> what are some other IDE tools to use with sql server 2000 and 2005? I
like
> query analyzer a lot and am not crazy about EM or SQL Workbench (or
whatever
> it is called these days).
> What does this community use when you are not using QA, EM or Workbench?
I
> like to type in T-SQL rather than be using the GUI (but that doesn't mean
I
> want to use isql/osql :-)
You might want to take a look at our Database Workbench -
works with MSDE, 7 and 2000 as well as some other database
engines.
It has GUI tools for table-editting, but no diagramming tools.
In two weeks, we will be releasing a new version with new features
and many GUI improvements.
Check it out at www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
|||Give Query Analyzer Tool from our website a spin. It's a free tool inclined
towards helping you analyze query plans better.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"Kyle Adams" <kadam@.aol.spammersbeware.com> wrote in message
news:udAs5PHjEHA.2556@.TK2MSFTNGP10.phx.gbl...
> what are some other IDE tools to use with sql server 2000 and 2005? I
like
> query analyzer a lot and am not crazy about EM or SQL Workbench (or
whatever
> it is called these days).
> What does this community use when you are not using QA, EM or Workbench?
I
> like to type in T-SQL rather than be using the GUI (but that doesn't mean
I
> want to use isql/osql :-)
>
>
|||I'd give SQL IDE from imceda a big look at.
http://www.imceda.com
Bryan
"Kyle Adams" <kadam@.aol.spammersbeware.com> wrote in message
news:udAs5PHjEHA.2556@.TK2MSFTNGP10.phx.gbl...
> what are some other IDE tools to use with sql server 2000 and 2005? I
like
> query analyzer a lot and am not crazy about EM or SQL Workbench (or
whatever
> it is called these days).
> What does this community use when you are not using QA, EM or Workbench?
I
> like to type in T-SQL rather than be using the GUI (but that doesn't mean
I
> want to use isql/osql :-)
>
>