Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to map Sybase Fields to DB2 Fields

Posted on 2011-03-23
14
Medium Priority
?
368 Views
Last Modified: 2012-05-11
How to map SybDataSource Fileds to DB2DataSource Fields.
It is unidirectional mapping,  a database acts as a translation key from one database to the other database.

For ex : I have Database_Name in Sybase how do i map to DB2 Database_Name
0
Comment
Question by:siddharthkool
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +1
14 Comments
 
LVL 40

Expert Comment

by:Gurvinder Pal Singh
ID: 35204423
are you writing a tool for migrating from Sybase to DB2?
May i know, why do you need to do this mapping
0
 

Author Comment

by:siddharthkool
ID: 35204454
yes im a newbie n trying to understand concept but not very much clear of how to do this mapping. I want to understand this so that i can code in java for the same logic.
0
 
LVL 40

Accepted Solution

by:
Gurvinder Pal Singh earned 500 total points
ID: 35204469
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
LVL 37

Expert Comment

by:momi_sabag
ID: 35205974
what do you want to code?
what are you trying to do?
0
 

Author Comment

by:siddharthkool
ID: 35206045
I have Database_Name property in Sybase driver how do i map to DB2 Database_Name property? If i give some property in through Sybase the same property must be selected in DB2.
0
 

Author Comment

by:siddharthkool
ID: 35206320
I have a properties table in sybase and want to map with properties table in DB2? How do i map the individual property of both the tables in different database. the fields in the both tables are the same.
0
 
LVL 24

Assisted Solution

by:Joe Woodhouse
Joe Woodhouse earned 500 total points
ID: 35212435
Take a look at Sybase's product PowerDesigner. You can get this on a free eval for 30 days.

You can point it at your existing Sybase database (via ODBC), reverse-engineer it, and then "Change Target Database" to DB2 and it will convert the physical design. You can also have it produce scripts to generate the DB2 version of your Sybase database.

Rather than fooling around doing this by hand, use the tool that does it for you and (on eval) is free. You do have to pay to continue to use it after the eval period, but the eval version has all functionality unlocked.
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 35221982
... not entirely saw we get to delete an EE question and get points refunded after viewing all the answers and declaring they weren't to our satisfaction.

The job of the experts here is to give good answers, not what the original poster wants to here. If expert consensus is very much not what the asker wants to hear, that is itself is commercially valuable information.
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 35221984
s/saw/sure
0
 

Author Comment

by:siddharthkool
ID: 35227367
@Joe Woodhouse: Sybase's product PowerDesigner will this convert the .class files to .java files too?
0
 

Author Closing Comment

by:siddharthkool
ID: 35228831
not solved,,, changed projrct
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 35229265
For the record and for anyone else looking at this entry in a search result, Power Designer is a database tool, not a code tool. It can give you scripts (code) for generating a database schema but it's not there to write your code for you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question