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

    SQL Server to Oracle migration : column semantics


      I am testing a migration from SQL Server 2012 to Oracle 12c using migration wizard of SQL Developer 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