Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

SQL CDC

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
SanPrg
Asked:
SanPrg
  • 2
1 Solution
 
Jim P.Commented:
What is CDC?
0
 
SanPrgAuthor Commented:
Change Data Capture.
0
 
Jim P.Commented:
Does that mean auditing?
0
 
Anthony PerkinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now