Roger Bjärevall

DbVisualizer Support
+ Follow
since Feb 19, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Roger Bjärevall

You can't. setFetchSize() cannot be used to fetch increments. Check scrollable result sets in JDBC as this seem more appropriate in your case. Another solution is to fetch all 500 rows and let JSP code control what should be presented of the cached data.

Regards

Roger
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,

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
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
Palla,

1. http://www.minq.se/forum/category.jspa?categoryID=4

2. DbVisualizer Personal includes database support for DB2 on z/OS. For other platforms; if there is a JDBC driver available then you may most likely can connect to it in DbVisualizer

3. DbVisualizer is great for standard database activities such as testing SQL statements, editing table data, exploring objects in the database and export/import.

Some users are satisfied with what the DbVisualizer Free edition offer while others decide to upgrade to DbVisualizer Personal which has a lot more features.

Best Regards

Roger
Leandro,

The choice of database tool is like most things a matter of taste. The main reason to choose DbVisualizer over SQL Developer is that DbVisualizer supports a lot more databases.

Give it a spin.

Best Regards

Roger
Gian,

For Oracle, DB2 and SQL Server DbVisualizer have built-in support for presenting explain plan data in a more readable style . For other databases you can run the appropriate commands that will generate the plan data and see the result in DbVisualizer.

Read more about the explain plan support in:

http://www.dbvis.com/products/dbvis/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId979712

Best Regards

Roger
Nirav,

Derby (also known as JavaDB) is supported in DbVisualizer. Read more about the database specific support here:

http://www.dbvis.com/products/dbvis/doc/main/doc/ug/databaseSpecific/derby.html

Unfortunately I don't have any experience with Artifactory.

I recommend you check with the JFrog people where to find the database file(s) and what JDBC URL to use while connecting in DbVisualizer (or any JDBC based interface).

Once you know the location of the database files (full path), then launch DbVisualizer and start the Tools->Connection Wizard to setup the connection. The Derby JDBC driver is bundled with DbVisualizer.

Regards

Roger
Gian,

(I wrote a rather long reply to your question, unfortunately when I pressed "Submit" i got:

"Aaack! You caught us with our pants down! Here we are, tinkering with the servers and you show up. How awkward! Try back in just a minute... Sincerely, the red faced JavaRanch staff."

and my reply was lost...)

To summarize my reply: database refactoring is a really difficult task to fully automate. I think we may see some refactoring support in the future, what, how and when is yet to determine.

Best Regards

Roger
Rogerio,

Sorry for the delay. I missed your post.

DbVisualizer is no rocket science but it is very mature and include a lot of utility features that makes DB admin and development easier.

Here are some of the major feature areas in DbVisualizer include:

- Schema Export with reverse engineering of DDL + export of table data
- Monitor feature which is used to periodically run SELECT statements and present the result in charts
- Professional table data editor with spreadsheet editing mode and row form mode
- Graphical query builder
- SQL Formatting
- Database object management with functions for create, alter, drop, etc. specifically for each of the supported databases
- Plug-in framework which allows integrating support for a database only by editing an XML file

Check the following web page for complete information:

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

Unfortunately we don't have an up-to-date comparison chart with Squirrel SQL.

Regards

Roger

Mourouganandame,

DbVisualizer does not include any versioning support for procedures.

Regards

Roger
Dar,

Oracle is one of the supported databases. In the current version it doesn't generate
DDL for indexes. PRIMARY KEYS and UNIQUE constraints are however supported.

The next feature version has the new "Export Table" feature which also generates
DDL for indexes.

Regards

Roger

Dar,

DbVisualizer Personal can generate the DDL for some databases. What DB are you using?

Regards

Roger
Chuck,

Thanks for your post.

Connection tree sorting was introduced a few years ago. Check the attached screenshot.

Best Regards

Roger

Vishal,

No I wouldn't say a 65K script it is too large. Give it a try. If memory is an issue
then you will need to extend the memory allocated for Java. Read more in:

http://www.minq.se/products/dbvis/doc/faq/faq.jsp#6.3

Best Regards

Roger