Recording changes

The Case

You need to keep an audit trail of changes made to the database during the database development. Keeping track of changes made to the database is a tedious and time-consuming procedure, which is not that critical when you are under increasing time-pressure to deliver the final phase of the project. It is so easy to put aside this task.

Main goals to be achived

• Fulfilling project requirements without increasing the development time
• Recording all changes made to the database throughout the project continuation on a regular basis.

Our solution is

Use Cross-Database Comparator Pro 6.0, Cross-Database Studio 6.0 in order to generate SQL comparison reports between current and previous database versions:

1. Select schema objects and/or data you want to keep an audit trail of the changes;
2. Configure comparison strategy in order to produce comparison reports, schedule comparison sessions etc.;
3. Run comparison session manually or automatically. Archive a comparison report in order to keep a log of database changes;
4. If required you can generate and keep the synchronization scripts together with a comparison reports;

Advantage of our solution

• Automated task ensures reducing time-consumption for developers
• The project requirements are fulfilled
• Elimination of the human error