Capture Change and Apply it with CDC & SSIS
Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Steve Wake is a Consultant at RevGen Partners with more than 20 years of experience in various IT organizations. Steve has experience in Manufacturing, Retail, Charities, Telecommunications and Financial Services organizations & switched to Consulting to share/expand/teach on his experiences with Microsoft Business Intelligence. Steve is also very involved in the SQL community, speaking at events across the country, blogging at wakebi.com, and is currently President of the Denver SQL Server UG.
- Austin SQL Saturday 41 Recordings