ohahaahr_at_hotmail.com wrote:
> 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
Look at heterogeneous services at http://tahiti.oracle.com.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Nov 23 2005 - 15:06:57 CST
