1 Reply Latest reply: Jul 18, 2014 7:15 AM by Kgronau-Oracle RSS

    blank space with table data on SQL Server - Oracle Migration

    860767

      Hi,

       

      I used SQL Developer Version 4.0.0.12 for Migrating Data from SQL Server 200 R2 to Oracle 11g.

       

      Referenced http://www.oracle.com/technetwork/database/migration/connect-sqlserver-1945229.html for Migration.


      Data Migrated Successfully, but some table field values found with blank space.


      While i checked found that blank space comes when SQL Server table has field with type char(5) and have data with less than 5 characters. So on migration, unused character space occupied with blank space


      Is its default conversion on Migration? any solution or any other method for Accurate and fastest migration.



      Thanks in Advance

       

      With Regards

      PMS