Solved

How to map Sybase Fields to DB2 Fields

Posted on 2011-03-23
14
340 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
  • 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
 
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now