DBArtisan Workbench

Question

DBArtisan Workbench

Ivy

Mr or Mrs. 500

Points: 529
More actions
October 5, 2004 at 9:57 am

#84215

Has anybody used the tool DBArtisan Workbench, or the professional version for that matter.
I'm currently trialing the product and would appreciate any reviews you may have, or recommendations for similar products.
DBArtisan Workbench - http://www.embarcadero.com/products/dbartisan/dbdatasheet_wb.html
Thanks in advance!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

mybid2003 SSCertifiable Points: 6620 More actions · Answer 1

I have been using DBArtisan since 6.0. The all new 8.0.0 version is awesome. Though the readme says that they support from SQL Server 7.0, 2000 and higher, You can use this to access 6.5 SQL instances as well.

I am very much impressed with this tool. Specially with this new version, Analyst Series will be very very helpful.

Let me know if you have any specific questions.

.

Ivy Mr or Mrs. 500 Points: 529 More actions · Answer 2

Thanks for the response.

To be honest, I haven't spent the time to review it much yet. My main interest is to understand what it does that I cannot do already with EM and Query Analyzer.

I use SQL LiteSpeed for backups and am very happy with that product, so the backup abilities which would be nice otherwise don't excite me all that much.

I'm having a difficult time justifying the price for what you get.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

I trialed it a couple of years ago and the feature I liked most was being able to administer heterogeneous DBMSs with one console. At the time, we had SQL Server and Oracle and I could deal with both of them without having to run two different administrative consoles.

Greg

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 4

The nice thing is that yes, you can administer DB2, Oracle, and SQL Server (which we do here) all via the same interface. What I LOVE about DBArtisian is that you can run reports on any object quickly and see information that is difficult if not impossible to find in Ent. Manager (SQLSvr). Like, space used by data vs. indexes by table in mb via a pie graph. A easily printable document of any object... table report gives you space used/unused, row counts, col names, indexes, SPs used by the table and the DDL for the table. Via the GUI you can reindex a tables indexes quickly, run update stats on specific objects easily... order the tables by least amount of rows, most # of rows.... (that is great because my boss is always asking, which tables are the biggest now ?). This is also a little better than the Ent. Manager in Oracle too.

Granted, if you don't have the extra cash to purchase this product you can get by easily with Ent. manager just fine, I agree, however, if you can justify it is very nice to have.

Ivy Mr or Mrs. 500 Points: 529 More actions · Answer 5

Thank you all for the responses. I'll keep working with it and then comes the biggest task of all, getting the ok to spend 3k on it

mybid2003 SSCertifiable Points: 6620 More actions · Answer 6

From my point of view, time saving is the most critical piece in justifying purchasing of tools like this.

If I goto my boss that I need a tool & If I could save 5 hours per week using the new tool at this price range, my boss would buy it.

Atleast thats how I see it. Correct me if I am wrong.

Markus had mentioned all the frequently used features.

I would suggest you spend some time with it to see how much time can you save. The CS people are very nice, if you need extension of the trial period, they would extend it.

.

Ivy Mr or Mrs. 500 Points: 529 More actions · Answer 7

Bringing back to life...

Well, I think I have the budget ok'ed for the product. In fact, I'll be purchasing the bundle (DBArtisan,ER/Studio and either change manager or Rapid SQL-you get to choose). Much cheaper than buying each separately. About 5k with the main. agreement.

So, before I buy, does anybody have any last words of advice about Embarcadero's product vs. others?

Thanks