sqlserver 2000 tables to oracle 9.2.0.1.0

[Hubert Mayr]

Hi!

I have a sqlserver 2000 database and want all that tables daily transfer to
my oracle 9.2.0.1.0 database.
what is the best way to do that?

thanks

[Hilary Cotter]

either using DTS, or Snapshot Replication.

I've just done this with snapshot.

All you have to do is set up an ODBC connection to your Oracle database, and
then enable it as a subscriber.

"Hubert Mayr" <hu...@gmx.net> wrote in message
news:10742516...@news.liwest.at...

[Chandrasekar Gopalan]

Hi -
You can use DTS import/export wizard to do this. Refer "Books
online" for more info.
Regards,
Chandra
--------------------
||From: "Hilary Cotter" <hil...@att.net>
||References: <10742516...@news.liwest.at>
||Subject: Re: sqlserver 2000 tables to oracle 9.2.0.1.0
||Date: Fri, 16 Jan 2004 08:17:06 -0500
||Lines: 21
||X-Priority: 3
||X-MSMail-Priority: Normal
||X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
||X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
||Message-ID: <#MJmLMD3...@tk2msftngp13.phx.gbl>
||Newsgroups: microsoft.public.sqlserver.replication
||NNTP-Posting-Host: ool-4353c4df.dyn.optonline.net 67.83.196.223
||Path:
cpmsftngxa08.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!tk2msftngp13.phx.gbl
||Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.replication:46744
||X-Tomcat-NG: microsoft.public.sqlserver.replication

[Helmut Knappe]

Hi Hubert,
you might check out DBMoto at
http://www.hitsw.com/products_services/dbmoto/dbmoto.html. Please tell me
what you think.
Regards, Helmut

"Hubert Mayr" <hu...@gmx.net> schrieb im Newsbeitrag
news:10742516...@news.liwest.at...