Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/create_secondary_database.sql

Created June 30, 2022 13:43
Show Gist options
  • Save vvgsrk/89ed55dac7520dfbadfbc642fa1dab62 to your computer and use it in GitHub Desktop.
Save vvgsrk/89ed55dac7520dfbadfbc642fa1dab62 to your computer and use it in GitHub Desktop.
Download ZIP
Create secondary database
Raw
create_secondary_database.sql
-- Create a replica of the primary database in the traget account
CREATE DATABASE AMADEUS_DYNAMIC_PRICING
AS REPLICA OF ORGANIZATION_CODE.ORGANIZATION_NAME.AMADEUS_DYNAMIC_PRICING;
-- Refresh a secondary database
ALTER DATABASE AMADEUS_DYNAMIC_PRICING REFRESH;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment