RE: Oracle to Sql Server

DTS
will only work for moving tables.  It will not bring triggers, indexes, RI, SP's or any other objects.  DTS is only good on transferring tables and the data within the tables when dealing with a non-SQL Server database (typical M$).
<SPAN
class=282164816-30082001> 
<SPAN
class=282164816-30082001>Dave

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Walthour, Jon (GEAE, Compaq)   [mailto:Jon.walthour_at_ae.ge.com]Sent: Thursday, August 30, 2001   12:27 PMTo: 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 - 12:20:51 CDT