Version history tool? 1

[unclerico]

I was just asked by a user if there is any kind of version history that can be kept for SQL 2000 Databases? For example, he wants to keep track of the values for some fields at at any point in time. My first thought is that there isn't and this would have to be a feature that he would need to create, something like a version history table that gets updated with the field name and its value each time the field changes (using a trigger or something). Are there any third party tools out there that do this? TIA.

 

[ptheriault]

Version history for the schema or for the data? If you are trying to track historical data your going to have to do that programatically. Like you said, create a hist table and dump history into it will a trigger. There are some 3rd party tool that can help with the schema.

- Paul
- Database performance looks fine, it must be the Network!

 

[unclerico]

thanks Paul, that's what I figured, just thought I would check it out.