How to convert Oracle PKs into Identity columns in SQL Server using SSMA RRS feed

  • Question

  • In SSMA for Oracle, I have gone to Tools -> Project Settings -> General and set "Convert Sequence Generator" to "Using column identity" however my PKs are not being converted to identity columns.

    How can I get my Oracle PK columns which are generally NUMBER(12,0) and are populated using Sequences to convert to Identity columns in SQL Server?

    Saturday, September 29, 2012 2:01 AM


All replies