|
|
Posted by arichie on 10/01/36 11:27
Thanks Simon,
We have around 20 tables to be transfered from sql server to Oracle
database. The current plan is use lined server and write a stored proc
in Oracle and grab the data using simple select into statement. This is
will happen every night and couple of tables have more than million
rows.
The question is whether linked server is reliable to do these kind of
data load use DTS. I have a very limitted knowledge in SQL Server. I am
trying to find a book/document which talks about the internal
architecture of linked server and dts. Preferably not by Microsoft.
Thanks
Allen
Simon Hayes wrote:
> I'm not really sure what you're asking for - can you be more specific?
> Does the information in Books Online ("Configuring Linked Servers" has
> a diagram of the architecure) not give you enough information? Both DTS
> and linked servers are possible ways to get data from Oracle, but
> they're very different solutions, so if you can give more details about
> what you need to know and what you're trying to do, someone may be able
> to point you in the right direction.
>
> Simon
Navigation:
[Reply to this message]
|