Thanks for the input, folks.

I had come to the idea of adding a publish/go live type column to my tables, although that would involve a *ton* of work.

The time between making a change in the OLTP db and "publishing" to the OLAP db could vary from minutes to days. So if Lempster is correct, that rules out snapshot repl.

And I'm fairly certain transactional replication can't be done, as one of our requirements is that the order in which the transactions are to be applied to the destination is not necessarily the same as the order on the source. Is this correct?

So I'm looking at merge or roll-your-own, both of which involve some sort of row-versioning, and a lot of work.

Anyone have any other ideas/guidance?

Thanks