Alex Rivera | Logout

Ways to Maintain Data History in SQL Server 2008 Database

Asked 2010-10-06T17:06:38.820
9

For a long time, we've wanted to create a case management system where no history is ever lost. When a change is made, we want to record that change, but have the ability to go back to any point in time and see what the record looked like. I wanted to pose this question to the Stack Overflow community to see what are some ways of doing this, is there technology already in place to achieve this?

Edit
Report

1 Answer

8

Yes, that technology definitely exists - it's a bit of an effort to implement it and do so correctly.

What you're looking for is called temporal databases - see some resources:

answered 2010-10-06T17:17:39.873

Your Answer