Networks

A bit of back ground information first

We have a dodgy point of sale

When a Transaction at one of our stores is done the information of the Transaction is emailed to our head office Database Stores are Running SQL Server 2005 Express Head office is running SQL Server 2000 Standard

The problem is that our point of sale is dodge and often Emails incorrect information from Stores to head office (I Recently Done some Tests which I indicate that about 20% of head offices Data is incorrect) this causes a head ache for our accounting, admin and IT Staff

What we are after is some type of Data compare application that will compare our Stores Databases To Our Head office Databases (Table by Table Row by Row Cell by Cell) which includes some type of mechanism to Correct the Data Discrepancies and Was hoping someone could Recommend a software application to do this I am Currently assessing Redgate : SQL Data Compare and Idera SQL comparison toolset

Key Requirements
-We are after something in which we can schedule The Runs during the night with the possibility of some type of command line option
- The ability to Generate a roll Back Script


Oh and one more thing our owner doesn?t like to spend any money Well (Which is why we are in this situation in the first place) so if there is something which is free for commercial use (I know this unlikely but ill try anyway) this would be greatly appreciated