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.