?
Solved

SQL CDC

Posted on 2014-01-19
4
Medium Priority
?
350 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

718 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