I have a DEV Vertica database and need to create a new TST Vertica database. During the past few months both administrators and users have had pretty-much wide open access to do what ever was needed to get things working. Thus, the internal Vertica configuration/metadata is not well tracked nor understood. Im looking for a way to export all the internal configuration details and metadata needed to 1) Document what the current configuration is, and 2) Deploy that configuration to a new TST Vertica database. Some of the things I am looking for are:
- ACCESS/Authentication/LDAP config
- Object DDL, Flex tables, Schemas, Sequences
- Anything else metadata related to be able to document/reproduce the configuration.