Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Possible bug converting from Oracle to NexusDB?

 Post Reply Post Reply
Author
Christophersen Alf View Drop Down
Member
Member
Avatar

Joined: 12 Oct 2011
Posts: 52
Post Options Post Options   Quote Christophersen Alf Quote  Post ReplyReply Direct Link To This Post Topic: Possible bug converting from Oracle to NexusDB?
    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??


Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2392
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down