locked
Migrating NULL values in tables from oracle to MS SQL RRS feed

  • Question

  • Hi,

    I am migrating Oracle 11g database to MS SQL server 2014 using SSMA.

    Currently, when I migrate data, all (null) values in oracle tables are migrated as NULL to SQL.

    However, I want to migrate null values in oracle tables to blank space in SQL.

    Is it possible?

    Is there any setting in SSMA which supports this?

    Thanks.

    Friday, September 5, 2014 11:02 AM

Answers

  • Hi ManiC24m,

    In SSMA, there is no setting we can modify to migrate null values in Oracle tables to blank space in SQL  Server. As Prashanth’s post, after the migration, you can replace the null values with blank space via the following Transact-SQL statements in SQL Server.

    USE <DatabaseName>
    Go
    UPDATE <TableName> SET <ColumnName>=''
    WHERE <ColumnName> IS NULL

    Thanks,
    Lydia Zhang

    • Marked as answer by ManiC24 Thursday, September 11, 2014 3:31 PM
    Monday, September 8, 2014 10:31 AM

All replies

  • I don't think you convert null values during the migration. After the migration you can do the update.

    --Prashanth

    Friday, September 5, 2014 2:27 PM
  • Hi ManiC24m,

    In SSMA, there is no setting we can modify to migrate null values in Oracle tables to blank space in SQL  Server. As Prashanth’s post, after the migration, you can replace the null values with blank space via the following Transact-SQL statements in SQL Server.

    USE <DatabaseName>
    Go
    UPDATE <TableName> SET <ColumnName>=''
    WHERE <ColumnName> IS NULL

    Thanks,
    Lydia Zhang

    • Marked as answer by ManiC24 Thursday, September 11, 2014 3:31 PM
    Monday, September 8, 2014 10:31 AM