CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-redshift
ITHelpGuy
ITHelpGuy

Reputation: 1037

Ways to create a copy of an existing Database in Amazon Redshift

I come from a Microsoft SQL Server background and of late working on Amazon Redshift. Was looking for options to create a copy of development database for QA. The quickest way to accomplish this in SQL Server would be to generate scripts with schema & data for instance or use SSIS. What are the different options to accomplish the same in Amazon Redshift.

Upvotes: 5

Views: 2455

Answers (1)

Julio Faerman
Julio Faerman

Reputation: 13501

The simplest way is taking a snapshot of your existing Redshift cluster and restoring to a new one. As Redshift is compatible with Postgres, you could also use Postgres backup tools, but it would be slower, more difficult to maintain and probably more expensive.

Upvotes: 1

Related Questions