Print Page | Close Window

Possible bug converting from Oracle to NexusDB?

Printed From: TMS Software
Category: Business Tools
Forum Name: Data Modeler
Forum Discription:
URL: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=2913
Printed Date: 21 Feb 2020 at 4:53pm


Topic: Possible bug converting from Oracle to NexusDB?
Posted By: Christophersen Alf
Subject: Possible bug converting from Oracle to NexusDB?
Date Posted: 17 Aug 2013 at 6:32am
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??





Replies:
Posted By: Wagner R. Landgraf
Date Posted: 17 Aug 2013 at 10:49am
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.



Print Page | Close Window