locked
Migration Oracle Partitioned Tables to SQL Server 2012 RRS feed

  • Question

  • We are migrating from Oracle 11gR2 to Sql Server 2012. We have opted for SSMA (version 5.2) as migration tool. Our Oracle schema has many partitioned tables. When we migrate these tables to SQL Server they get migrated as single table.

    Are we missing some configuration? Does SSMA support migration of partitioned tables from Oracle?

    Friday, September 14, 2012 2:04 PM

Answers

  • Hello,

    This is by design.

    Please see the following post:

    "Thank you for contacting SSMA Support.

    Migration of Oracle Partitioned Tables is not supported by SSMA. Partitioned tables are migrated as a Non-partitioned simple tables.

    Partitioning of the these Tables in SQL server is required to be done manually as per the physical database architecture planning and logical drives of the server system.

    Any partition maintenance (adding or dropping or truncating the partitions) related code need to be re-rewritten in SQL Server."

    http://social.msdn.microsoft.com/Forums/en/sqltools/thread/a7115324-cb6e-422b-83ff-780dd37bb88a

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by jetleyh Saturday, September 15, 2012 6:22 AM
    Friday, September 14, 2012 4:24 PM