Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!ndsoftware.com!skynet.be!newspost001!tjb!not-for-mail Reply-To: "Matthias Hoys" From: "Matthias Hoys" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server References: <12l9dcsplo28vd5@corp.supernews.com> Subject: Re: Some Data from SServer to Oracle - Options ? Date: Sat, 11 Nov 2006 11:57:16 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-RFC2646: Format=Flowed; Response Lines: 29 Message-ID: <4555ac8c$0$5522$ba620e4c@news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: a9fff64f.news.skynet.be X-Trace: 1163242637 news.skynet.be 5522 81.244.7.73:1179 X-Complaints-To: usenet-abuse@skynet.be Xref: news.f.de.plusline.net comp.databases.oracle.misc:76677 comp.databases.oracle.server:189314 "klabu" wrote in message news:12l9dcsplo28vd5@corp.supernews.com... > Looking for ideas: > Need some data (within Oracle/Lnux) from SQLServer(2K) on a CONTINUAL > basis. > > Does NOT need to be Real-Time...can be like Mat. View. > > What are my options in impleneting this process ? > > thanks > (and Yes I'm also asking the M$ guys also) > > > -- > 10gR2/Linux > > You could install the Oracle client software on the SQL Server box, and then create a DTS package to transfer data from SQL Server to the Oracle server. You have to do the "mapping" of tables one by one though. Scheduling can be done with the SQL Server agent, and you don't need any extra software licenses to use this. Matthias