ok perhaps replication isnt what i need

it seems like more of a dev / back up / disaster recovery method

I am looking into ways of moving data into a reporting database and trying to keep the data real time

if i need to write procedures that will organise the data after the replication then this kind of defeats the object for me

i think 🙂