Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

How to map Sybase Fields to DB2 Fields

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
siddharthkool
Asked:
siddharthkool
  • 5
  • 4
  • 2
  • +1
2 Solutions
 
Gurvinder Pal SinghCommented:
are you writing a tool for migrating from Sybase to DB2?
May i know, why do you need to do this mapping
0
 
siddharthkoolAuthor Commented:
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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
momi_sabagCommented:
what do you want to code?
what are you trying to do?
0
 
siddharthkoolAuthor Commented:
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
 
siddharthkoolAuthor Commented:
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
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
Joe WoodhousePrincipal ConsultantCommented:
... 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
 
Joe WoodhousePrincipal ConsultantCommented:
s/saw/sure
0
 
siddharthkoolAuthor Commented:
@Joe Woodhouse: Sybase's product PowerDesigner will this convert the .class files to .java files too?
0
 
siddharthkoolAuthor Commented:
not solved,,, changed projrct
0
 
Joe WoodhousePrincipal ConsultantCommented:
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

Technology Partners: 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!

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now