Solved

How to map Sybase Fields to DB2 Fields

Posted on 2011-03-23
14
360 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:gurvinder372
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:
gurvinder372 earned 250 total points
ID: 35204469
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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 250 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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
This video teaches viewers about errors in exception handling.
Suggested Courses

632 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