Solved

SQL CDC

Posted on 2014-01-19
4
338 Views
Last Modified: 2016-02-10
Hi,
I have task to create CDC for a few tables, I worked on CDC a little bit before,
I found SSIS has a new task is CDC, my question is:
what's the deferent between Tsql CDC and SSIS CDC?
And which one better for tracking data ?

Thanks
0
Comment
Question by:SanPrg
  • 2
4 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 39793200
What is CDC?
0
 

Author Comment

by:SanPrg
ID: 39793235
Change Data Capture.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39793248
Does that mean auditing?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 39798077
what's the deferent between Tsql CDC and SSIS CDC?
They are different animals:
CDC is an Enterprise only tool for auditing changes to tables.
CDC in SSIS is a tool to load incremental changes.
1

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now