Error in migrating data from Oracle 7.3.4 to SQL Server 2008

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

Answer 1

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.