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

Rupendra

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 VBR.py 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_C

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.

Rupendra

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?

Thanks,
Rupendra