Thank you for your forum post.
Firstly, SQL Compare is not tool you need to evaluate, this would be SQL Data Compare. SQL Compare compares and deploys database objects, whilst SQL Data Compare can be used to compare and deploy data.
Secondly SQL Compare and SQL Data Compare are not alternatives to Microsoft's SQL Server Replication Technologies. From the sceanrio you have described, it appears that you need to implement SQL Server Merge Replication.
In theory using the Command line Interface of SQL Data Compare you configure SQL Data Compare to perform an automated deployment. From experience, the frequency you wish to synchronize is not feasible. A frequency of once or twice an hour maybe achieved and I would only recommend a one way deployment not the two way deployment you are seeking.
I recommend that you take a look at this Knowledge Base artilce using this LINK.
The article was first published in September 2008 for SQL Data Compare V6 and V7, however the advice it contains is still valid for the latest V10.
SQL Compare and SQL Data Compare will help you deploy from the Superset server to each client in turn when you first configure the scenario you have described.
Please download and evaluate to see if it meets your need.