October 28, 2015 at 8:14 am
We are migrating from oracle 11g to ss 2014, using the migration tool to move schema's and data. we are encountering an issue with data coming over cleanly. specifically; dates and numbers. Dates are coming over as NULL at least 85 % of the time and numbers are sporadically coming over as NULL.
I'm looking for troubleshooting tips or articles related to the situation above. I have not found anything useful to-date. If someone has had a similar issue and is will to share thier solution; that would be awesome.
October 28, 2015 at 8:30 am
Generally in the past when I have done Oracle to SQL migrations, we migrate everything as NVARCHAR(MAX) (Yes I know over kill), into a staging database, then use functions like isdate, isnumeric etc to find out what values are failing. Its not 100% but worked for us.
You could also try the following link https://msdn.microsoft.com/en-GB/library/ms151817.aspx for the type mapping, eg INT in oracle wants to be numeric(38) in SQL
October 28, 2015 at 8:36 am
Thanks, I'll give this a shot and let you know how it works out.
November 3, 2015 at 6:59 am
My team gave this a try, and it worked very well for us. Thanks for the help.
November 3, 2015 at 7:03 am
Not a problem
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply