Re: Hi,

From: GovindanK <gkatteri_at_gmail.com>
Date: Tue, 17 Jul 2007 10:31:30 -0700
Message-ID: <469CFCF2.20503@inbox.lv>

SQLDeveloper has an option to connect and pull data from SQLServer / MySQL; Not sure if this can be invoked from the command line. May be you can take a look at that.

HTH
GovindanK

Dennis Cutshall wrote:
> Hi,
>
> We have a mixed environment of SQL Server and Oracle. Because of
> this, we now have a need to transfer table data between them. This
> would be on a continuing basis, probably on off-peak hours. Our
> preference would be to have the Oracle side drive the process, that
> is, Oracle pulling table data from SQL Server. Is anyone currently
> doing this, and would pass on information on how it is done? We know
> about Migration Workbench, but that is more for a one-time conversion
> than a scheduled nightly routine. Any information or tips would be
> appreciated.
>
> Dennis
>
> Dennis Cutshall
> Data Base Administrator
> University of North Dakota ITSS
> Phone: (701) 777-4109
> Fax: (701)777-3978
> E-Mail: DennisCutshall_at_mail.und.nodak.edu
> <mailto:DennisCutshall_at_mail.und.nodak.edu>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 17 2007 - 12:31:30 CDT