title: secure database distribution to external clients
body: <p>We want to distribute / synchronize data from our Datawarehouse (MS SQL Server) to external customers (also MS SQL Server). The connection has to be secure, because we are dealing with trusted data. Transmission of data from our system to external client system must be via the http/https</p>
  
  <p>In addition it is possible that the clients still run their systems with an older database schema, so already existing tables and columns should be transmitted and non existing ones should be ignored.</p>
  
  <p>Its most likely that we will have large database updates and the updates have to arrive in almost real-time.</p>
  
  <p>And it is definitely necessary that the data is stored in a client side datawarehouse / SQL database.</p>
  
  <p>The whole process should also include good monitoring possibilities in case something goes wrong.</p>
  
  <p>We started to develop our own .NET solution but I thought it should be almost a common problem to exchange data between different systems.</p>
  
  <p>Does anybody know about an existing solution which we can adapt to our scenario?</p>
  
  <p>Any help is appreciated!</p>