Oracle replication and MS SQL-server

Hi

In our company we have an ERP-system, which runs on an Oracle 10g.

In the warehouse we are now installing a transport system for moving pallets from one location to another. This system runs on ms sqlserver.

If people in the warehouse wants the transport system to move a pallet, they make a transport order in the ERP-system. This generates a record in the table TRANSPORTORDER in the oracle.

TRANSPORTORDER looks like this:

Id PalletId FromLocation ToLocation Status -- -------- ------------ ---------- ------

1  1000     A10          B12        2
2  4564     B12          F11        1
5  1002     A23          C24        3
6  5353     A12          A13        0
7  1234     A33          B44        0

The status means:

0 - Not send to transport system yet
1 - Waiting for transport system to complete job
2 - Ok. Job completed
3 - Error. Job could not be not completed

I need to send all records with status 0 to the sqlserver. The status must then change to 1, so that I don't send the same job 2 times.

The transport system now executes the transport order (if possible), and returns an answer in the table JOBSTATUS on the sqlserver.

JOBSTATUS looks like this:

Id TransportId Status
-- ----------- ------

1  1           2
2  5           3

According to this jobstatus, I must update TRANSPORTORDERS in my oracle.

There will be aproximately 10 transportorders every minut, and the job completes 3-15 minutes after the transport is ordered.

My question is: What is the best way of sending data between the oracle and the sql-server?

Should i use Oracles replication feature, or is there a better way?

Let me hear your opinion...

Regards,
Ole Received on Wed Nov 23 2005 - 13:50:00 CST