SQL Server Performance

Transfering Tables from Oracle to SQL Server 2000

Discussion in 'SQL Server DTS-Related Questions' started by ljc, Feb 2, 2006.

  1. ljc New Member

    Using the Wizard I have created a DTS package to transfer a Oracle table to a SQL Server database. The data is transfered but not the indexes. Is it possible to transfer the indexes over? I am using the Microsoft OLE DB Provider for Oracle to connect to the Oracle database and I am using the Microsoft OLE DB Provider for SLQ Server to connect to the SQL Server.

    Laura Cerniglia
  2. ji06 New Member

    Hi,

    When you used the wizard to create the dts package, did you use the transfer object option?
  3. FrankKalis Moderator

Share This Page