I find that even though NUMBER should be converted to NUMERIC and NUMBER as float to Float, NUMBER(0,0) is converted to Float instead of NUMERIC
Perhaps an idea to check?
Shouldn't also primary keys as Intger in Oracle be converted back to AutoInc? On conversion opposite way Autoinc is converted to Integer (without creating a sequence), so perhaps primary key integer evt. plus sequence should be converted to AutoInc and sequence deleted??
Hi Alf,
data type conversion between different databases is always questionable and depends no the application. Especially databases that have such different concepts are sequences versus autoincrement. That's why you can define custom conversion maps so you can define which Oracle field will convert to each NexusDB field. There might be specific situations that manual tweaking would be needed, though.