I've type of a such scenario:
Here i have to synchronize local server database with primary DB server(example: computer systems at work are attached to office server plus they utilize it just like a local server, to ensure that no sync is needed.BUT computer systems in other office use their local server too and that we need synchronization between your offices although the primary DB server.). When i see i cant use SQLCompact here. It is possible to provider to complete the server-to-server synchronization from the customer? If no can someone give a sample of solution of methods to handle such situation?
You can examine out Microsoft Sync Framwork 2.0. You will find new database sync companies that may support your needs. For example, you'll be able to sync directly between two SQL Server Compact Edition databases.