Here's my general scenario, I can elaborate as needed.
I need to be able to move (publish?) a subset of my database to a copy of my db on another server.
Both servers are on the same network, same domain (and are in fact linked).
It's a client/server setup, the source is OLTP, the destination is OLAP.
The subset is user-defined, and the schedule is user-defined - but I don't think we can actually schedule changes. Basically, my OLTP users want a short delay between making their changes and having those changes visible to the OLAP users so they do QA.
The database is not big (400 MB); any subset should not normally exceed 4 MBs (in my estimation).
The number of rows would be range between a couple from a few tables - a few hundred from a couple of tables.
The rows in the destination db can be locked to users for no more than roughly 3 seconds.
Any thoughts or ideas how to proceed? I'm thinking snapshot replication, but have never used any replication.