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
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Application To Sync Data between multiple Microsoft SQL Server Databases
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