CODEWITHSUNDEEP
databaseamazon-redshiftamazon-redshift-spectrum
Mallikarjun Nuli
Mallikarjun Nuli

Reputation: 21

I need to copy a database from one Redshift Cluster to another cluster

I need help in moving a database from one Redshift cluster to another Redshift cluster. Here, I'm not copying a table. I want to copy a database. Could some one help me on this.

Upvotes: 2

Views: 3054

Answers (3)

DJo
DJo

Reputation: 2177

You have two options:

Option 1: Take a snapshot and create a new cluster by restoring the snapshot and drop the databases which you do not require. You can have a cross region if required.

Option 2: Unload the table data from the current database to S3 and Copy the data to new database after you create a new one, here you need to manually create all the dependencies like users, groups, access, etc..

Upvotes: 0

Jon Ekiz
Jon Ekiz

Reputation: 1022

You can take a snapshot of the current database. And restore it once you create the new database.

Upvotes: 0

Rahul Gupta
Rahul Gupta

Reputation: 1802

  • Using s3 as temp storage

    If both clusters in the same region then
    UNLOAD to s3 from cluster 1
    then
    COPY from S3 to cluster2.

  • Using cluster snapshot.

    Create a snapshot of the source cluster, then restore the snapshot as the destination cluster.

    If I’ve made a bad assumption please comment and I’ll refocus my answer.

Upvotes: 1

Related Questions