Copy Settings to Clipboard Use this choice to copy all settings to the system clipboard.If you have a lot of databases, more efficient is to disable zabbixsender from zbxORA and use zbxorasender to combine the data for all databases. This already is in batches but one batch for every database, one zabbixsender for every database. Use this choice to save the settings to a file This causes a new zabbixsender process every time data is to be sent to zabbix. Use this choice to open the file chooser dialog, in which you can select a settings file Removes the saved defaults and restores the regular defaults Use this choice to initialize the settings with default values These are then loaded automatically when open an Export Schema dialog Use the Settings button menu to accomplish this: If you use a number of common settings, you can save them to individual files that you can load as needed.
If you often use the same settings, you can save them as the default settings for this assistant. The data for each individual value of this type is then exported to a separate file and a DbVisualizer variable referencing the file is inserted in the main export file. But the data that was exported is all messed up. I inserted some data programmetically into DBeaver, in one of the connections, and then used the feature Export Resultset to export to another server. You can select a variable from the menu to insert it in the pattern field at the care position. I am using DBEaver 6.2.0 with SQL Server. All variables that can be used are listed in the menu that is displayed when you click the blue arrow to the right of the field. Another example of the flexibility of DBVisualizer is the ability to create Folders in the database tab. Compare this to SQuirreL, which has Vacuum and Analyze in the context menu for each table. You can use some of the pre-defined DbVisualizer variables ( $$.txt. DBVisualizer is missing some PostgreSQL specific syntax such as vacuum and analyze are not well supported.