replacing truncated data, how?
Posted on 2010-01-12
We just migrated data from Oracle database into SQL Server 2008.
However, since we were having problem using SQL Server dts for this migration, due to date, timestamp and other Oracle-SQL Server compatibility issues, we decided to use Oracle's SQL Developer tool to extract data from Oracle to .csv file and then to SQL Server.
Problem is that user just found out 3 weeks after conversion that some data was truncated.
There are a few comment fields with large character lenght that lost some data from Oracle to .csv file.
I am trying to fix this problem by just importing only those comment fields.
Is there a way, perhaps easier way to just add truncated data without having to delete entire table and reload data?
The user doesn't want to go this route because they have added so many new records since we went live.
Any ideas how to fix this?
Suddenly, my blood pressure has gone up due to this sudden discovery.
Thanks a lot in advance