Finally got it to work, here's the correct sql - I am using the unique+increment field Trades.ID to return the newest Trade for a given SymbolID :

select a.SymbolID, a.CurrentPrice, a.TotalValue,...

Hi,

I probably should add that this process occurs only on 2 tables in A, not the whole db.

I was considering transaction replication, but since it's not a direct 1-to-1 replication,...

Thanks, that definitely sounds like the way to go. So the polling process would be something like :

1 - Poll change log table

2 - Read last, say, 100 rows

3 -...