SSMA v6.0 - Migrate Oracle Data ONLY RRS feed

  • Question

  • Hi,

    Need help on migrating Oracle DB to MS SQL.

    I just want to migrate ONLY the Table data. No Indexes, No Triggers.

    Can u pls help and explain step by step what I need to do.



    Thursday, January 15, 2015 4:28 AM


  • Hi ITMan2000my,

    According to your description, you want to use SSMA to migrate table data from oracle to SQL Server without any triggers and indexes. Based on my research, it is impossible to achieve that since the indexes and triggers will get created in SQL Server along with other objects. To work around this issue, please drop the triggers and indexes from the corresponding tables in SQL Server after migration.

    Besides, to migrate the table data without triggers and indexes, I recommend you to use SQL Server Import and Export Wizard following the steps below.

    1.Start the SQL Server Import and Export Wizard.

    2.Select a data source(Microsoft OLE DB Provider for Oracle ), give server name, credentials, database name.

    3.Choose the destination(SQL Server Native Client), and type the server name, select Windows Authentication or SQL Server Authentication, and select the database.

    4.Select source tables, click next.

    5. Click next to save and run a package. Last , click finish.

    For more information about the process, please refer to the article:http://msdn.microsoft.com/en-us/library/ms140052.aspx

    Michelle Li

    Friday, January 16, 2015 8:53 AM