I have an existing SQL Server 2005 database that runs our inventory application. We are looking at using a new on-line ordering which has it's own database.If we use this new , 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.So my question is... what is the best way to transer…See More