SQL Server Performance

BULK ONE-TIME MIGRATION FROM ORACLE TO SQL SERVER.

Discussion in 'SQL Server 2008 Integration Services' started by petejordan, Nov 29, 2010.

  1. petejordan New Member

    re: BULK ONE-TIME MIGRATION FROM ORACLE TO SQL SERVER.
    I want to know the best way to migrate tables from Oracle 9i
    to SQL Server '08 R2 as a cutover i.e. NO updates, no CDC (Change
    Data Capture) with Attunity. Just SELECT INTO the SQL Server tables,
    which DO NOT yet exist and shutdown the Oracle server for good.
    I do not see any sample SSIS pkgs which do a SELECT INTO where
    tables on the SQL Server do not yet exist.
    Thank you,
    XPXJ
    petejordan, Nov 29, 2010
    #2

  2. FrankKalis Moderator

    Welcome to the forum!
    I'm no SSIS expert, but I believe there is an option that lets you create the tables right before the import.
    FrankKalis, Nov 29, 2010
    #3

Share This Page