6 Replies Latest reply on May 16, 2014 11:08 AM by Dermot ONeill-Oracle

    SQL Server to Oracle migration : column semantics

    user12017111

      I am testing a migration from SQL Server 2012 to Oracle 12c using migration wizard of SQL Developer 4.0.0.13. The problem that I am facing is all the generated table creation scripts have CHARACTER semantics for character columns. I would like the semantics to be BYTES. As the generated tables and columns are  several thousand its not possible to manually change the semantics.

       

      CREATE TABLE account_dod (

        account_id VARCHAR2(16 CHAR) NOT NULL,

       

      I cant seem to find any option to change the semantics during generation. Does anyone know of any option that I can set so that migration wizard will generate all columns as BYTES ?

       

      Many Thanks