Best way to copy schema from one database to another in different network

What can be the best way to copy schema from a database to another which is in different network? Since the clusters are in different network, I cannot use EXPORT TO or COPY FROM. 

I thought of using to have schema backup in the first cluster, move the backup to second cluster and restore it there. But, it seems that VBR backup and restore require same cluster topology.


  • Navin_CNavin_C Vertica Customer
    You can try EXPORT_OBJECT or EXPORT_CATALOG function to get the objects definition out of one cluster and deploy the ddl for all objects through the same cluster to another cluster through vsql.

    Hope this helps.
  • Thanks Navin for the reply. Yes, I can get DDL and deploy it in another cluster.

    I also want to copy data to another cluster. Any idea how it can be done?


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file