You find your Bookmarks under the Scripts tab in the navigation area to the left in the main DbVisualizer window. The content of a Bookmark is one or more SQL statements. It may also be associated with a Connection, a Catalog and a Schema, to be used when executing the statements. This information is displayed, and can be edited, in the lower part of the Scripts tab, along with information about the file that holds the Bookmark. If you don't want to see these details, you can disable it with the Show Details toggle control in the right-click menu for a node.
Creating, Editing and Organizing Bookmarks
You can create a new Bookmark by selecting the Bookmarks node in the tree and clicking the Create File toolbar button. This adds a new node in the tree, with the default name selected so that you can replace it with the name you want to use. You can also rename the Bookmark later using the Rename right-click menu item.
The folders and the Bookmarks within a folder are ordered alphabetically and cannot be changed manually.
With a Bookmark opened in an SQL Commander tab, you can of course execute its statements by clicking the Execute toolbar buttons as usual, but you can also open and execute a Bookmark directly by selecting it in the tree and using the Open in SQL Commander and Execute operations in the right-click menu.
Adding a Bookmark as a Favorite
If you are using a Bookmark very often, you may find it more convenient to add it to the Favorites area. You can drag and drop a Bookmark from the Scripts tab to the Favorites area, or via the Add to Favorites right-click menu operation.
It's easy to share your Bookmarks with someone else because they are stored as regular files. The files are located in a subfolder of the DbVisualizer user preferences folder named Bookmarks. The user preferences folder is typically a subfolder named .dbvis in your home folder.
To share some of your Bookmarks with someone, we recommend that you use DbVisualizer to create a separate Bookmarks subfolder for the shared Bookmarks. You can then use any external tool to create a file archive (e.g. a ZIP file) of that subfolder and send it to your friend or colleague. He or she can then extract the files into the local DbVisualizer user preferences Bookmarks folder.
Using Quick Load