Keeping an audit trail of changes

The situation

You need to maintain an ongoing record of changes made to the database throughout your project. When you've got a dozen or more developers, under increasing time-pressure to deliver the latest phase of the project on time, it's too easy to put off this tedious and non-critical step.

Key challenges

How we can solve it

You can address this issue in two ways. On your production servers by creating an automated task, and on your development servers using SQL Source Control.

In addition to helping you maintain an audit trail, SQL Source Control helps developers collaborate, and improves productivity, saving you time overall.

In Development Environments

Use SQL Source Control to keep a history of development changes.

SQL Source Control links your existing source control system with SQL Server Management Studio, bringing the benefits of version control and change management to database development. This means you have a record of who made each change, when, and why.

  1. Download an install SQL Source Control
  2. Link your database to source control.
  3. Make development changes normally.
    When you are happy with your changes, commit them to source control.

In Production Environments

Use the SQL Compare command line interface to schedule a task to archive a report of the changes as a nightly job:

  1. Create a script to execute SQL Compare to compare the schema of the current database with the schema of the previous version, produce a report of the differences, and archive the report.
  2. Create a script to execute SQL Data Compare to compare the data in the databases, produce a report of the differences, and archive the report.
  3. Add a scheduled task to run the scripts using the Windows Scheduled Task Wizard.

Benefits of our solution

Support & documentation

from $495
SQL Compare is available in Pro and Standard versions, or as part of a bundle.

Volume discounts apply.

Got a question?
0800 169 7433

Try a 14-day fully functional free trial of SQL Compare.

SQL Developer Bundle

With our full set of SQL development tools you can code fast, collaborate easily, and deploy accurately. Sound good?

Find out more...

SQL Source Control boxshot

Version your databases with SQL Source Control, a plug-in that connects your source control system to SQL Sever Management Studio.

Find out more...

Deployment Manager

Take the micromanagement out of deployment with Deployment Manager, a tool that makes the deployment process fast, reliable, repeatable, and accessible to your whole team.

Find out more...

Schema compare for Oracle?
Works just like SQL Compare, but for Oracle databases.

Schema Compare for Oracle