title: How to synchronize two SQL Server 2005 databases?
body: <p>I'm looking for a tool (best for free) which can synchronize two SQL Server 2005 databases.</p>
  
  <p>I have a sql database that is hosted on a server and another sql database that is hosted on aclient. Both have the same database schema. Each client has its own sql server because the application needs to run offline.</p>
  
  <p>The client is being connected to the company network regularly (each day). When the connection is being established, I would like to run a delta synchronization with the tool. Not all data from the server database is required on the client database, just a subset which is determined by the user of the client computer.</p>
  
  <p>Do you know a tool which supports this?</p>
  
  <p>Best Regards<br />Oliver Hanappi</p>