I used SQL Developer Version 126.96.36.199 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
CHAR columns are always padded with space.
SQL> create table test (col1 char(5), col2 varchar(5));
SQL> insert into test values ('hi','Hi');
1 row created.
SQL> select length(col1), length(col2) from test;
More details can be found here: 11.4.1 The CHAR and VARCHAR Types