Hi

We user Red Gate tools (Compare and Data Compare) and Powershell scheduled to run everyday using Windows Task Scheduler.

Just a quick overview of the process:

- We use Powershell to download the files from TFS (trunk project folder) to a directory

- Using Powershell and a RedGate Project File we compare a Production database (in a daily restore environment) to the directory

- If there are discrepancies we email the Red Gate HTML report to the DBA Admins.

Same goes for Data Compares however we only compare tables that hold static data items which are source controlled.

Hope this helps...