Not sure which category this falls into but I wonder if someone can point me in the right direction.
On one of our local servers we have an SQL database. We also have another database on our web server. Currently we update stock on our web server via DTS once a day. I would like to make this real-time so customers can always see our correct stock. How can this be done ?
You can use transactional replication for this. Latency should be just a couple of seconds, except when you have large transactions (such as an index rebuild) that affects the table in the publication. How latent it'll be in that case will depend on the size of the large transaction and your hardware resources.