Hi,
I think you can use DESC VQL DATABASE statement to export the metadata of your VDP database through a job in scheduler.
If I have to do an import/export for my VDP metadata, I always use the import/export scripts of the denodo-db-tools.
You can check out the section “USING THE IMPORT/EXPORT SCRIPTS FOR BACKUP AND/OR REPLICATION” from the Virtual DataPort Administration Guide.
Hope this helps!