nowsathns/readme.md

Last active February 28, 2020 13:40

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nowsathns/b9a79eed0ed8a9be420011d48ea91e33.js"></script>
Save nowsathns/b9a79eed0ed8a9be420011d48ea91e33 to your computer and use it in GitHub Desktop.

Temporal Tables

Raw

    

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment