Skip to main content

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

  • February 13, 2014
  • 2 replies
  • 20 views
Rupendra
Forum|alt.badge.img+1
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.


    2 replies

    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Participating Frequently
    • February 14, 2014
    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
    Forum|alt.badge.img+1
    • Rupendra
    • Author
    • Participating Frequently
    • February 14, 2014
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement