I am trying to develop a concept for my back-office system so that I can define the work that needs to be done. I am not a programmer so please be gentle with me!
I have an MS SQL database sitting behind my (VB.Net2) my website. The database has a table into which orders go when customers buy online.
What I want to do is to have a copy of this table on my local server and use a web service to feed the local database from the website database.
So my idea is that as soon as the website database receives a new record it initiates the web service which sends the record down to the local databse.
Simple in theory but is this feasible in practice?
Thanks in anticipation.
Chris