Is there any way to specify data type mapping for migration in DBArtisan

Hi,

I am trying to migrate DB2 to oracle using DBArtisan. I want to specify data type mapping for the column during migration. e.g TIMESTAMP in DB2 should be created as DATE in oracle.

I did not find any way to specify the same. Is there any way to specify ?

Thanks,

Anand

Parents
  • I believe you'll want to do something like this: <pre style="color: #080000;"> [color=#0000ff]Dim[/color] myProject [color=#0000ff]As[/color] [color=#000080]Project[/color] [color=#0000ff]Dim[/color] myProjects [color=#0000ff]As[/color] [color=#000080]Projects[/color] [color=#0000ff]Dim[/color] diagramList [color=#0000ff]As[/color] [color=#000080]StringObjects[/color] [color=#0000ff]Set[/color] myProject = myProjects[color=#000080].Item[/color](ProjectName) diagramList[color=#000080].Add[/color](diagramName) myProject[color=#000080].AddDiagrams[/color](diagramList) </pre> <p style="color: #080000;">You'll get your project from the project list. Create a list of diagrams (diagramList) of the diagrams you want in the list and then add that list to the project. I haven't tested this out and I'm sure there needs to be some modification to it but it should give you a general idea how to get started.
Reply
  • I believe you'll want to do something like this: <pre style="color: #080000;"> [color=#0000ff]Dim[/color] myProject [color=#0000ff]As[/color] [color=#000080]Project[/color] [color=#0000ff]Dim[/color] myProjects [color=#0000ff]As[/color] [color=#000080]Projects[/color] [color=#0000ff]Dim[/color] diagramList [color=#0000ff]As[/color] [color=#000080]StringObjects[/color] [color=#0000ff]Set[/color] myProject = myProjects[color=#000080].Item[/color](ProjectName) diagramList[color=#000080].Add[/color](diagramName) myProject[color=#000080].AddDiagrams[/color](diagramList) </pre> <p style="color: #080000;">You'll get your project from the project list. Create a list of diagrams (diagramList) of the diagrams you want in the list and then add that list to the project. I haven't tested this out and I'm sure there needs to be some modification to it but it should give you a general idea how to get started.
Children
No Data