Replication SQL D to Amozon Redshift

[ajay1998]

Hi Team, 

we have on-Prem SQL DB (whole Database ) need to Replicate to Redshift. Please let me know the step and is Attunity can replicate without any manual changed in DDL . 

will automatically create table in Redshift ?

Thanks

Ajay Gupta

[Madhavi_Konda · Accepted solution]

Hi Ajay,
Yes. You can use Attunity Replicate to replicate the data from SQL DB to Amazon Redshift.

You can achieve the following using Attunity Replicate:
Schema generation and data type mapping
Full load of source database tables
Incremental load of changes made to source tables
Application of DDL changes made to the source tables.
Synchronization between full load and CDC processes.
Manual control is also available if needed.

Thanks,
Madhavi

[ajay1998]

Hi Madhavi,

Thanks for help. 

need clarification on 2 point

Application of DDL changes made to the source tables.    not getting , could please explain in details.

Schema generation and data type mapping---- this will generate automatically or need to do manual data type changes in mapping

Thanks

Ajay

9899059037

[Madhavi_Konda · Accepted solution]

Hi Ajay,
Application of DDL changes made to the source tables->Any kind of ddls you do at source will be automatically applied to the target.

Schema generation and data type mapping->You don't need to do anything manual. These will be generated automatically. What I was trying to say was you can adjust the datatypes for the target manually. This option is available and you can ignore if you son't want it.

Thanks,
Madhavi