nowsathns/readme.md

## readme.md

      
    Raw
  

              readme.md
            
          
Features
CT
CDC
Temporal


Tracks Data Changes
Yes
Yes
Yes


Tracking mechanism
Synchronous
Asynchronous
Synchronous


Require enabling at Database Level
Yes
Yes
No


Require enabling at Table Level
Yes
Yes
Yes


Historical Data retention
No
Yes
Yes


Ability to Recover data from history
No
Yes
Yes


Requires change in current code
Yes
Yes
No


Table requires primary Key
Yes
Yes
Yes


Schema changes to the table allowed
Yes
No
Yes


Ability to analyze trends in data
No
No
Yes


Available in Standard Edition of SQL Server
Yes
No
Yes


History data is secure
No
No
Yes


Can you truncate history table?
Yes
Yes
No


History data resides in the same table
No
No
yes


Can you truncate main table?
Yes
No
No


Dependency on SQL Server Agent running
No
Yes
No
Features	CT	CDC	Temporal
Tracks Data Changes	Yes	Yes	Yes
Tracking mechanism	Synchronous	Asynchronous	Synchronous
Require enabling at Database Level	Yes	Yes	No
Require enabling at Table Level	Yes	Yes	Yes
Historical Data retention	No	Yes	Yes
Ability to Recover data from history	No	Yes	Yes
Requires change in current code	Yes	Yes	No
Table requires primary Key	Yes	Yes	Yes
Schema changes to the table allowed	Yes	No	Yes
Ability to analyze trends in data	No	No	Yes
Available in Standard Edition of SQL Server	Yes	No	Yes
History data is secure	No	No	Yes
Can you truncate history table?	Yes	Yes	No
History data resides in the same table	No	No	yes
Can you truncate main table?	Yes	No	No
Dependency on SQL Server Agent running	No	Yes	No