|
|
Posted by Erland Sommarskog on 10/01/28 11:27
arichie (arichie@gmail.com) writes:
> 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.
I would suspect that DTS is a better solution for this than linked
tables, if nothing else for performance. Certainly, this is precisly
the scenario for which DTS is intended. (But I have never used DTS myself.)
In the linked-server scenario, SQL Server is basically a client to the
other server that uses OLE DB to connect to the remote server. (Tip is
to use Oracle's own OLE DB Provider. Microsoft has not updated their
MSDAORA for recent Oracle releass.) Internally, SQL Server transforms
the access to client API calls. I don't think there is much literature
that discusses linked servers as such.
For DTS, please have a look at http://www.sqldts.com and
visit the group microsof.public.sqlserver.dts.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|