CSV File Format
You can add instances in bulk. The prerequisite is to have a CSV file with the following format:
“action:instance-import”
“dbms-type:sqlserver”,“given-name:SQLTEST001”,“host:local.dbwtest1.com”,“port:1433”,“admuser:sa”,“admpassword:Password1”,“group:Test”,“engine:true”,“service:standard”
“dbms-type:sqlserver”,“given-name:SQLTEST002”,“host:local.dbwtest2.com”,“port:1433”,“admuser:sa”,“admpassword:Password2”,“group:Test”,“engine:true”,“service:standard”
“dbms-type:oracle”,“given-name:ORATEST001”,“host:local.dbwtest3.com”,“port:1521”,“sid:ORCL”,“admuser:sys as sysdba”,“admpassword:Password3”,“group:Test”,“engine:true”,“service:standard”
———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Let’s explain the tags more with the following table:
| Tag | Description | |
| dbms-type | The database type (sqlserver, oracle, postgres, mysql, sybase) | |
| given-name | The display name for the instance. | |
| host | Host IP | |
| port | Port number | |
| admuser | This user will be set as the properties user. If ‘engine’ is set to true, this user will be used to create the dbwatch schema | |
| admpassword | The password for the admin user | |
| group | The group to place the instance in. If ‘engine’ is set to true, the default values used during schema creation are from this group. | |
| engine | If a dbwatch schema should be created (true, false). | |
| service | The licensing level to set for this instance. |
Uploading Instance File
Open ‘Server’->‘Upload resource’ menu.
A window will appear where you can upload resource files. Click on “Select Files” then choose the CSV file for bulk installation.
Afterwards, click on “Upload”.
After successfully uploading the Import.csv file.
You will see the 3(highlighted in yellow) additional instances that we’ve added.
← Adding a MySQL Instance / Discovering Database Instances →
Post your comment on this topic.
Ole wrote: Jul 2, 2021
It should be "given-name", and the blank line is not necessary.
Alexander Veitschegger wrote: Jul 2, 2021
it isn't clear if given-name or given name is correct. Is the blank line between the entries a 'must'?