Dear All,
Guess I need some help here.
We are planning to replicate tables from Oracle to SQL Server 2012 and planning to use SQL Server: CDC for Oracle.
I have already setup this part. Now changes in the Oracle table will be logged to ct.<table_name>_CT.
http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx
However, I'm really at lost on how to proceed from here. I'm actually more of a Oracle DBA.
How do I perform initial load and subsequent increment load? I supposed it's not part of the CDC scope and I have to make use of SSIS?
Anyone have a guide to do it? I have tried to google and mostly are for sql server to sql server.
Appreciate your help.
thanks