Why DB Visualizer?

[Prakash Dwivedi]

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?

[Hans Bergsten]

Hi,

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

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

Hans Bergsten

[Amir Iqbal]

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,

[Sagar Rohankar]

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.

[Roger Bjärevall]

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]

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]

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]

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]

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]

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.

[Mourouganandame Arunachalam]

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

I'm !

[Gian Franco]

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]

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]

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]

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]

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]

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.