LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Database CVS? (https://www.linuxquestions.org/questions/linux-software-2/database-cvs-398800/)

newuser455 01-02-2006 06:40 PM

Database CVS?
 
I am developing a project which requires a database, and I need something that will track changes made to the database. Does anyone know of some sort of cvs type thing, but for databases? Thanks.

bulliver 01-03-2006 12:43 PM

Depending on your DB, this is quite often built in. For example, check out MySQL's 'binary log' which records all transactions that change the DB tables:

http://dev.mysql.com/doc/refman/4.1/en/binary-log.html

I am sure other DBs have similar features.

newuser455 01-03-2006 01:17 PM

Yes, but is there any way to actually "undo" a change that is made?

gilead 01-03-2006 02:07 PM

Are you talking about changes to the db schema? If so, your create and alter scripts should be in the CVS repository (and tagged for each release).

Or are you talking about the data in the tables? In that case it's easier to look at triggers if you're inserting directly into the tables or if you're using packages (Oracle for example) and inserting via an API you can build audit code into the packages.


All times are GMT -5. The time now is 05:35 PM.