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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply