title: The best technology to synchronize data between different database schemas?
body: <p>I have an existing SQL Server 2005 database that runs our accounting/inventory application.  We are looking at using a new on-line ordering framework - which has it's own database.</p>
  
  <p>If we use this new framework, we will need to transfer the on-line ordering data (inventory, prices, orders, customers) - almost realtime - to and from, our existing inventory database. The transfer of data doesn't have to be real-time, but it has to be quick. Both databases will be in SQL Server.</p>
  
  <p>So my question is... what is the best way to transer data  back and forth between two databases, with have different schemas? </p>
  
  <p>Replication? SSIS? What would you suggest, and why?</p>
  
  <p>Any help would be appreciated!</p>