Re: Multiple databases from SQR running from Process scheduler

Posted by [IP Address: 194.154.214.69] 'Tom Namla' on August 29, 2001 at 03:22:47 EST:

In Reply to: Multiple databases from SQR running from Process scheduler posted by [IP Address: 194.154.214.69] 'Shrine Dava' on August 28, 2001 at 17:05:51 EST:

Talk to your DBA about linking the servers, both SQL Server and Oracle are able to create online connections between each other.

I did it to avoid having to do data extracts, and just select the data out of the other DB directly.

Describing the setup procedure would be a bit much to describe here but it's in both the oracle docs and SQLServer docs.

Name:
E-Mail:
Subject:
Message: : Talk to your DBA about linking the servers, both SQL Server and Oracle are able to create online connections between each other. : I did it to avoid having to do data extracts, and just select the data out of the other DB directly. : Describing the setup procedure would be a bit much to describe here but it's in both the oracle docs and SQLServer docs.