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 SQLWays Wizard. 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.

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

- Cloud path - is a path to our Amazon S3 bucket, where all the data files will be uploaded. This path should be specified as it is shown on the screenshot, without “https:” part.

- 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 “Target Options” page on the “Advanced” tab, like it is done on the screenshot:

NOTICE: To make an import into the Redshift database, your Redshift cluster and S3 bucket should be created in the same region!

If you don't have Access Key id and Secret Access Key, then you need to go to Your Security Credentials page in your amazon account and create them. More information about these keys can be found in this article: Where’s My Secret Access Key

After setting all the options and running the conversion process in the Export directory we will find all the files generated by the tool:

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 directory to this S3 bucket:

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.

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

Oracle to Redshift migration information

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

Link to Amazon S3 Service

Link to Amazon Redshift Official Page

If you have any other questions regarding the usage of our tool, please contact our support team: support@ispirer.com