redshift database migration on aws n.
Skip this Video
Loading SlideShow in 5 Seconds..
Redshift Data Migration PowerPoint Presentation
Download Presentation
Redshift Data Migration

Redshift Data Migration

1 Views Download Presentation
Download Presentation

Redshift Data Migration

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Redshift Database Migration on AWS

  2. Amazon Redshift database is a cloud-based data warehouse solution. With AWS DMS (Amazon Web Service Data Migration Service), you can transfer data from databases that are supported by it to the target database Amazon Redshift. • Redshift data migrationis convenient, fully automated, and can be completed without human intervention. But this is subject to fulfilling several criteria. · Generation of schema and data mapping is done · The total load is on the source database tables · Full load processes and CDC (Change Data Capture) are synchronized · All changes to a schema in DDL (Data Definition Language) are made to the tables at the source · Changes at source tables are made by incremental data.

  3. Redshiftdata migration involves several steps. The process starts with moving the data with the AWS DMS to an Amazon S3 bucket. Once the files are transferred, Amazon S3 automatically moves all the intended files lodged in S3 to the Redshift data warehouse. As pointed out, the full process is automated but with an exception. It is not so when AWS CLI or DMS API is used for Redshift data migration. In such instances, to get access to S3, Access Management (IAM) path along with an AWS identity has to be established first. Coming to the Redshift data migration,a few basicprocedures have to be observed for utilizing an Amazon Redshift database as a target for AWS DMS. · The Amazon Redshift cluster has to be launched with an AWS Management Console and all the critical info like user name, password, and the database name for both the AWS account and the Amazon Redshift cluster have to be noted. All these are necessary for ultimately creating the target Amazon Redshift. The Amazon Redshift endpoint being used by the cluster has to be connected through a network to the AWS DMS replication instance. · To transfer data to the Amazon Redshift database, AWS DMS has to use an Amazon S3 bucket. On the other hand, an IAM role has to be created if AWS CLI or DMS API is used to make a database for Redshift data migrationwith the target database being Redshift.

  4. · AWS DMS transforms BLOBs, CLOBs, and NCLOBs to a VARCHAR. However, Amazon Redshift does not support data types of VARCHAR which are more than 64 KB. However, there are certain restrictions in using Amazon Redshift as a target database for AWS DMS. The following aspects are not supported by Redshift data migration. · Migration or replication of data by AWS DMS is not possible with a name that starts with (­_). · When mapping of transformations is used to change the schema name on the target. · Support is not provided by AWS DMS to an application of a DELETE statement to a multi-column primary key, especially when the key columns are a reserved word. Follow these pointers for Redshift data migration.