database-migration
database-migration copied to clipboard
Max precision in sql server is 38
I've had issues with numeric and decimal since max precision in sql server is 38 and in exasol 36, i've made quick fix by adding this case when PRECISION > 36 then 36 else PRECISION end
.
Then i've added binary bwith this line
when 173 then '"' || column_name || '"' ||' ' ||'VARCHAR(2000000)' --binary