We have a table in oracle that needs to be pushed to sql server a few times a day. Actually if we can load both db's with the same table we can push just the changes to sql*server if that can be done. I was thinking of avoiding a gateway and doing it in XML. I know oracle can push it, can sql*server then receive and process it?
thanks
steve