Hi,
I have 2 seperate databases on different machines on a lan.
I would like to replicate a ~3 million row table with 10 fields from one 
database to the other, but i only really need 2 fields (both of type 
integer)  from this table to be replicated to the second database. Is it 
possible to replicate data from a view, or only certain fields from a 
table? It seems a waste to replicate all the fields I don't need (they 
would be changing frequently, and cause pointless replication/traffic).

Ideally, i would create another schema (eg called 'replicated_data') on 
the second machine, into which i'd replicate bits and pieces from the 
first database. Is this possible, or do i have to replicate the full table?

Regards,
Richard.