Hi, I'm just wondering if the following scenario is appropriate:
I have an ecommerce application. using sql server, it has 2 databases - database1 which is located on site, and contains all the product information, order info, backend infrastructure etc... database2 is in our remote datacenter. certain tables from database1 are replicated to database2. Currently, when a customer places an order, information is stored directly in database2 - there is then a DTS package that runs every so often that copies the required info into database1.
What i propose, is to re-architect the application, so that when an order is placed, the order is placed onto amazon sqs que. A service (on our in house service) then listens to the queue and picks up the order, and adds it to database1.
This is obviously significantly simplified, but am i on the right track?