locked
Error in migrating data from Oracle 7.3.4 to SQL Server 2008 RRS feed

  • Question

  • Hi,

    We are using SSMA 5.2 to migrate database from Oracle 7.3.4 to SQL Server 2008. It is smooth in convering and synchronizing objects. However, when doing data migration, an error "ORA-00907: missing right parenthesis" occurred if the Oracle table contains NUMBER column. We've tried to migrate table without NUMBER column and it can done successfully. Please advise.

    Thanks,

    Andy

    Wednesday, May 23, 2012 10:26 AM

Answers

  • Hi Andy,

    NUMBER column is a column name. What is the column type?

    Getting Started with SSMA for Oracle: http://msdn.microsoft.com/en-us/library/hh313198.aspx.

     

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    • Marked as answer by Maggie Luo Thursday, May 31, 2012 9:35 AM
    Thursday, May 24, 2012 8:47 AM