Skip to main content

How to create DB link between two vertica databases

  • June 14, 2019
  • 1 reply
  • 2 views
iadarsh

Hi, I want to perform QA on Stage and DWH databases.
Problem is that my staging database is present on different Vertica server and DWH database on different.

I want to create a DB Link between these two vertica database servers.

How can I do that?

    1 reply

    skeswani
    Forum|alt.badge.img
    • skeswani
    • Participating Frequently
    • June 14, 2019

    you can either pull data or push data

    see
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm

    Push
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/EXPORTTOVERTICA.htm

    Pull
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingData.htm

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement