Solved

How to map Sybase Fields to DB2 Fields

Posted on 2011-03-23
14
342 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Securing Jmx Console and web console 2 64
get weblogic logged in user in java 2 57
GUI builder for Eclipse? 8 27
Shell Script on AIX 7 62
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

919 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

12 Experts available now in Live!

Get 1:1 Help Now