RE: Hi,

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: "'DennisCutshall@xxxxxxxxxxxxxxxxxx'" <DennisCutshall@xxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 16 Jul 2007 17:43:56 +0100

Dennis,

What you probably want is to use Oracle Transparent Gateway for SQL Server. 
This allows you to create a database link in your Oracle database that connects 
to SQL Server, and you can use INSERT INTO...SELECT FROM...@DBLINK syntax to 
pull data.  

Keep in mind that SQL Server table names are usually lowercase, so you'll have 
to double-quote them in your SQL. 


Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dennis Cutshall
Sent: Monday, July 16, 2007 12:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Hi,

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@xxxxxxxxxxxxxxxxxx

==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
//www.freelists.org/webpage/oracle-l
  • Follow-Ups:

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2007