This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes Why DB Visualizer? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Why DB Visualizer?" Watch "Why DB Visualizer?" New topic
Author

Why DB Visualizer?

Prakash Dwivedi
Ranch Hand

Joined: Sep 28, 2002
Posts: 452
I mean, is there any special feature provided by DBVisualizer which are not there in DB2's UI Tools,

Personally I found DB2 Development center quite useful?

Prakash Dwivedi (SCJP2, SCWCD, SCBCD)
"Failure is not when you fall down, Its only when you don't get up again"
Hans Bergsten
Author
Ranch Hand

Joined: Dec 01, 2003
Posts: 106
Hi,

You find a feature overview here, along with online demos for some of then:

<http://www.dbvis.com/products/dbvis/features/>

Hans Bergsten


Hans Bergsten, hans@gefionsoftware.com<br />Author of O'Reilly's<br />- JavaServer Pages,<br />- JavaServer Faces<br /><a href="http://www.hansbergsten.com/" target="_blank" rel="nofollow">http://www.hansbergsten.com/</a>
Amir Iqbal
Ranch Hand

Joined: Jun 23, 2007
Posts: 97
well in my opinion you should try "mysql-gui-tools-5.0-r14-win32.exe"
becuase i found DB Visualizer very slow but this tool is really fast. you may also use MySql Front, MySql Yog, Toad etc.... these are also very good tools.

Regards,


i am Java +ve Now !
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

Amir Iqbal wrote:well in my opinion you should try "mysql-gui-tools-5.0-r14-win32.exe"
becuase i found DB Visualizer very slow but this tool is really fast. you may also use MySql Front, MySql Yog, Toad etc....

And that will be MySQL specific, DBVis is platform and database vendor independent. So buy once and use it any where with any database.

[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Amir,

DbVisualizer is a multi database and cross platform tool while the MySQL GUI Tools works only with MySQL. So obviously it will not work with DB2.

Regards

Roger
nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
comparing DBVisualizer the free download version with free download version of Toad i prefer TOAD by far. It not only has more features, its much more user friendly as well.
Prakash Dwivedi
Ranch Hand

Joined: Sep 28, 2002
Posts: 452
nikil shar wrote:comparing DBVisualizer the free download version with free download version of Toad i prefer TOAD by far. It not only has more features, its much more user friendly as well.


Nikil may you elaborate on the extra features provided by toad?
nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
absolutelty,

with free download of toad you can

view/edit stored procedures

execute multiple sql statements without having to comment out other sql statements bu highlighting the sql you need to execute

create scripts for tables/sequences etc

create sequences from the drop down menu instead of writing the whole syntax yourself

and the list goes on .....


you cant do all the above with free version of DB Visualiser.


Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Nikil,

Don't forget that the free TOAD also comes with a number of limitations:

- Allows only two concurrent database sessions
- Save Data limited to first 100 rows only
- 60 day expiration date
- Only one active DB session per client
- Does not permit multiple Toads to run (lacks option)
- Nag screen upon startup with commercial message
- Disabled features shown but grayed out (i.e. inactive)
- SQL Modeler removed

Note also that it was last updated 4 years ago.

Best Regards

Roger
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
I haven't tried it, but the functionality looks promising and there is nothing wrong with the price.

Currently I work with Sybase, Mysql, Oracle and Microsoft SQL and I didn't find a good general tool. I have had a bad experience with Toad which I still use occasionally.

Only I read that the performance is slow and you can't edit stored procedures. Is this true?

Also I want to know the plans of the future before I'm going to use the tool. How are updates handled?

Thanks for your feedback.



Remko (My website)
SCJP 1.5, SCWCD 1.4, SCDJWS 1.4, SCBCD 1.5, ITIL(Manager), Prince2(Practitioner), Reading/ gaining experience for SCEA,
Mourouganandame Arunachalam
Ranch Hand

Joined: Oct 29, 2008
Posts: 396
What is the use of a tool with multi OS + multi DBs - DBA features - Editing features (eg. sp editing) = ?

I'm !


Mourougan
Open Source leads to Open Mind
Gian Franco
blacksmith
Ranch Hand

Joined: Dec 16, 2003
Posts: 977
Mourouganandame Arunachalam wrote:What is the use of a tool with multi OS + multi DBs - DBA features - Editing features (eg. sp editing)


There are at least two different scenarios;
1.) you might be having a product portfolio with a variety of os + db combinations
2.) you might be using third party software (e.g. project management tools, hour registration tools, etc.) with a variety of os + db combinations

In both cases you might like to be able to connect to these systems with a single tool.

Kind regards,

Gian


"Eppur si muove!"
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Remko,

Performance isn't bad and you can edit stored procedure for the databases you mention. In next feature release there is also click-run support for procedures.

We are currently working with the next feature release. It will deliver some interesting features such as:

- Execution of stored procedures
- Auto-create table at import
- Re-designed bookmark management
- SQL statement auditing log
- Export table data (incl. binary data) + DDL
- Import of binary data
+ more...

Regards

Roger
Roger Bjärevall
DbVisualizer Support
Greenhorn

Joined: Feb 19, 2009
Posts: 25
Mourougan,

What is the use of a tool with multi OS + multi DBs - DBA features - Editing features (eg. sp editing) = ?

Nothing of what you state above is true.

I really recommend that you check the feature matrix posted a number of times on this forum. Here it is again:

http://www.minq.se/products/dbvis/features/features.jsp?page=matrix

For screenshots, feature tour and online demos check the following:

http://www.minq.se/products/dbvis/features

Best Regards

Roger
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
Roger,

Thanks for your feedback and mentioning of the new features.

I work with different databases at the same time so DbVisualizer could be a business case for me.

Running stored procedures is for me a must have.

But I haven't found a roadmap of new features on the of DbVisualizer website. Is it available?

Also when I buy a version will I receive updates or do you offer a some update subscription

When I've some time between projects I would like to try your product. Problem as always is that I wish a week had 1000 hours.


nikil shar
Ranch Hand

Joined: May 25, 2008
Posts: 116
hi Remko,
apologies for going off on a tangent but i just noticed you are preparing for SCBCD, what books/resources are you using for your preparation ??


ta.
Remko Strating
Ranch Hand

Joined: Dec 28, 2006
Posts: 893
You should start a new thread for that, but I use now EJB in Action which is a nice practical book. My preparing is now writing code for my customers using EJB and this book is very helpful.

Regarding DB Visualizer I've discovered on the website that you get updates for one year and you could get a subscription after the initial year for more updates.

This leaves for me one question what is the roadmap for development?

Thanks.

 
jQuery in Action, 2nd edition
 
subject: Why DB Visualizer?