DBSync Cloud Replication (Source apps with Amazon Redshift)

Most of the features of DBSync Replication will work the same irrespective of the database. The general process of Replication Source apps to Database and Database to Source apps is explained in the below links.

http://help.mydbsync.com/docs/display/CloudReplication/4-Source apps+to+Database

http://help.mydbsync.com/docs/display/CloudReplication/5-Database+to+Source apps

The functionality that is specific to Redshift database Replication is mentioned below.

Update Database Schema:

• To generate schema in Redshift database, the user must have Permission to generate Schema in Redshift database.

• DBSync Cloud Replication Creates schema and Tables metadata if it does not exist in Redshift database.

Source to Database (Clean Copy):

• Clean Copy creates Schema and Tables if it does not exists in Target Database and insert records from source belongs to the Object selected.

• In Redshift 'NULL' Values in INSERT/UPDATE is not supported. So, the following default values will be updated for all the fields which contain 'NULL' values.

Source to Database:

• Inserts or Updates records based on the Timestamp value in Redshift Database.

• In Redshift 'NULL' Values in INSERT/UPDATE is not supported. So, the following default values will be updated for all the fields which contain 'NULL' values.

Database to Source:

• While replicating from Redshift database to source, default values in Redshift database are removed.

Amazon Redshift Database details in DBSync Replication Profile

The following details should be entered in DBSync Replication console. Connection can be tested by clicking on Test Connection button. Click on Save to save database details in your profile.