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

    blank space with table data on SQL Server - Oracle Migration




      I used SQL Developer Version 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