DDL and Data Migration to Redshift

There are some specific points to consider when migrating table and data definitions from different databases to Redshift using SQLWays Wizard. First of all, to be able to load data into the Redshift database, we need to have an Amazon S3 bucket and create a folder in which we will copy/upload text files with data. We also need to have an “Access key id” and “Secret access key” which will give us the appropriate permissions to load data from files located in an Amazon S3 bucket into our Redshift database.

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

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

- Access key id - used to gain access to data files stored in the cloud.

- Secret access key - a key that is used to gain access to data files stored in the cloud.

All this information must be set on the “Target Options” page on the “Advanced” tab, as shown in the screenshot:

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

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

After setting all the parameters and starting the conversion process, in the export directory we will find all the files generated by the tool:

We need to copy all the generated txt files with data to our Amazon S3 folder. To do this, we need to go to Amazon S3 and upload files to the created folder.

Then we need to upload all the .txt files from the export directory to this S3 bucket:

Once the files have been uploaded to the Amazon S3 cloud, we can start the import process.

This way our tool will load all the converted definitions and data into our Amazon Redshift database.

Here you can find more information about the entire Amazon Redshift database migration process and the services that Amazon provides:

Oracle to Redshift migration information

Recorded demonstration of the entire migration process to Amazon Redshift

Link to Amazon S3 Service

Link to Amazon Redshift Official Page

If you have any other questions regarding our tool, please contact our support team at support@ispirer.com