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.
|
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. |
Yes, but is there any way to actually "undo" a change that is made?
|
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. |