SQL Server 2000 to Oracle 10g data migration
599094Sep 20 2007 — edited Oct 3 2007(Using the SQL Developer workbench)
I migrated a SQL 2000 server to 10g successfully (created a new user/schema with Oracle and migrated the structure over), but there was an error moving the views over. I wasn't really concerned with the views as the data and structure is more important.
So I left the views alone and went to migrate the data into the now existing structure. For whatever reason, it will NOT migrate data from a few different tables. Oracle truncates column names in at least two of the tables since they are over 30 characters long, but I didn't think this was the problem (maybe it is?). There is a "warning" (yellow triangle with !) in the error log which says something to the effect that it can't insert an empty string into the table despite the fact that row allows null. Since the log isn't very descriptive, I suppose it could just be a warning, however, NO data is transfered.
Can anyone suggest fixes to this issue?