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
    ljc, Feb 2, 2006
    #2

  2. ji06 New Member

    Hi,

    When you used the wizard to create the dts package, did you use the transfer object option?
    ji06, Feb 4, 2006
    #2

  3. FrankKalis Moderator

    FrankKalis, Feb 6, 2006
    #2

Share This Page