From DFarnsworth@Ashleyfurniture.com Thu, 30 Aug 2001 10:20:51 -0700 From: "Farnsworth, Dave" Date: Thu, 30 Aug 2001 10:20:51 -0700 Subject: RE: Oracle to Sql Server Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Message 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$).   Dave -----Original Message-----From: Walthour, Jon (GEAE, Compaq) [mailto:Jon.walthour@ae.ge.com]Sent: Thursday, August 30, 2001 12:27 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle to Sql Server Easy. Use SQL*Server's DTS (data transformation services) to pull the data from Oracle into SQL*Server.   Jon Walthour -----Original Message-----From: Apps Sol [mailto:apps_sol@hotmail.com] Sent: Thursday, August 30, 2001 12:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Sql Server 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