tool for documenting database and software changes

1

I'm currently working on a php project with 3 other people. I need a free software which can help me document the changes/revisions on the database and on the application that were developing.

Wern Ancheta

Posted 2011-06-25T08:32:30.013

Reputation: 5 822

Maybe you want to be a bit more specific. If you are working with other people, is the revision control system you're using not enough? – slhck – 2011-06-25T08:36:36.507

1Could you not just use git? Or is there some special functionality that is required? – slotishtype – 2011-06-25T10:04:46.107

@slotishtype: I'll try using Git, thanks for the comment. – Wern Ancheta – 2011-06-25T12:30:59.607

Answers

4

As slhck suggests, I would use a revision control system to record changes, whenever you check in a change you have an opportunity to type in a message stating the reason for the change.

For database structure changes I use a revision control system to manage a set of SQL DDL commands "create table ...; create index ..." which I edit whenever I make a change (even if I normally do so by "alter table" etc). This then preserves a history of changes to the database structure. I use end-of-line comments in the DDL to record the purpose of the fields.

If this is insufficient for you, you might consider editing your question to clarify what you need.

RedGrittyBrick

Posted 2011-06-25T08:32:30.013

Reputation: 70 632