Ispirer Ispirer
 


Ispirer Home Page Request SQLWays

DDL and Data Migration to Redshift

There are some specific moments that you need to take into account while migrating table definitions and data from different databases to Redshift using the Ispirer Migration and Modernization toolkit. First of all to be able to load data into Redshift database we need to have Amazon S3 bucket and create a folder where we will copy/upload the text files with the data. Also we need to have an “Access key id” and “Secret access key” that will give us appropriate privileges to load data from files located in Amazon S3 bucket to our Redshift database.

Options Setting

So to generate correct import scripts with appropriate commands to native utilities we need to specify all this information in the tool:

- “Bin directory” - is a path to the psql.exe utility that will be used to load the definitions and data into Redshift database.

- “Cloud path” - is a path to our Amazon S3 bucket, where all the data files will be uploaded.

- “Access key id” - that is used to get access to the data files stored on cloud.

- “Secret access key” - key that is used to get access to the data files stored on cloud.

All this information should be set on a “Choose a Target Database” page on the “Advanced” tab, like it is done on the screenshot:

Running the Export

After setting all the options and running the export process in the results folder we will find all the files generated by the tool:

Uploading the Data Files

And we need to copy all the generated txt files with the data to our Amazon S3 folder. To do that we need to go to the Amazon S3 and in created folder upload the files.

And then you need to upload all the .txt files from export folder to this S3 bucket:

Running the Import Process

After uploading the files to the Amazon S3 cloud we can run the import process.

Thus, our tool will load all the converted definitions and data to our Amazon Redshift database.

Additional Information

Here you can find some additional information about the whole migration process to Amazon Redshift database and the services that Amazon provides:

1. Oracle to Redshift migration information

2. Recorded Demo - Recorded demonstration of the whole migration process for Redshift as a target database direction.

3. Link to Amazon S3 Service

4. Link to Amazon Redshift Official Page


Ispirer Home Page Request SQLWays

sqlways/specifics/redshift/ddl-and-data.txt · Last modified: July 19, 2017, 12:38:11 AM by anastasiya.shpakava
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement