Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle to Sql Server

RE: Oracle to Sql Server

From: John Lewis <jlewis_at_punchnetworks.com>
Date: Thu, 30 Aug 2001 11:11:29 -0700
Message-ID: <F001.0037D765.20010830095658@fatcity.com>

You
may need to do some tweeking of the tables - but most every table/view moves fine.
It
will not move pl/sql or triggers.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Walthour, Jon (GEAE, Compaq)   [mailto:Jon.walthour_at_ae.ge.com]Sent: Thursday, August 30, 2001   10:27 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: Oracle to Sql Server
  <SPAN
  class=147212416-30082001>Easy. Use SQL*Server's DTS (data transformation   services) to pull the data from Oracle into SQL*Server.    
  Jon
Walthour        

    <FONT
    face=Tahoma size=2>-----Original Message-----From: Apps Sol     [mailto:apps_sol_at_hotmail.com] Sent: Thursday, August 30, 2001     12:07 PMTo: Multiple recipients of list     ORACLE-LSubject: Oracle to Sql Server<FONT     face=Arial size=2>
    Hello Folks,
 

    I am looking for some cool script to move all the database objects     

    across from Oracle 8.1.7 to Latest Sql Server (ver ???)     frequently.
 

    Is there any particular way we can do it to automate this     ??
 

    BTW: I want to pledge $20 or even willing to pay yearly subscription     and it would be a good
    idea to Send out a Pledge form to everyone . to keep the greens     coming..
 

    Cheers
    RK
 
Received on Thu Aug 30 2001 - 13:11:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US