I have two sqlserver2k databases on different servers on the same
network. I need to push recently inserted/updated data from one to the
other, but the databases have different schemas, i.e. the data needs to
be transformed during transfer. Also I need this synchronisation to be
as close to real-time as possible.
I am not a database expert, I am a C# coder. What would be my best
solution?

You could accomplish this with triggers or have a scheduled job that
runs every n minutes and kick off a DTS package /Stored proc
If it was in the same format I would say go for replication but it
looks like that is not the case


http://sqlservercode.blogspot.com/