Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Why DB Visualizer?

 
Ranch Hand
Posts: 452
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Author
Posts: 106
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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

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

Hans Bergsten
 
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
Ranch Hand
Posts: 2908
1
Spring Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
DbVisualizer Support
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 452
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 893
Tomcat Server Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


 
Ranch Hand
Posts: 398
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the use of a tool with multi OS + multi DBs - DBA features - Editing features (eg. sp editing) = ?

I'm !
 
blacksmith
Posts: 979
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
Roger Bjärevall
DbVisualizer Support
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 893
Tomcat Server Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 893
Tomcat Server Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
Yes, my master! Here is the tiny ad you asked for:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic