Lempster (2/18/2014)

---

If you only want a short delay between data being inserted into one database and appearing in the other, snapshot replication won't work for you. (Well, depending on exactly what you define as 'short' you could run the snapshot Agent very frequently, but it's overkill for your requirements). Transactional replication will work as mentioned in the first reply.

Regards

Lempster