Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, August 9, 2017

Using CDC Control Component for Initial Load with Read-Only Database

SQLServerCentral » Latest topics
Using CDC Control Component for Initial Load with Read-Only Database
I have an active CDC enabled SQL Server database with 4 tracked tables that I need to load into Amazon Redshift.

To do this I’m using the native SSIS CDC components to create an initial load, followed by a daily incremental load. 

No comments: