Hi ppl

I have an existing b2c system on infinity server . i am planning to migrate 
it to websphere commerce server . Can any body suggest me some tools for ora
cle database migration .

Thanks
Pravar

[ Post a follow-up to this message ]

There is a utility that IBM wrote to assist with Oracle to DB2 migration
back in the v5.4 days helping us move our WebSphere v4 repository
across.  I have a Convert_Oracle-to-DB2_Vp2.pdf in my repository that
outlines this tool and is accompanied by a zip.  Rather old mind you.
Comes from the WF421 class lab so I'm not at liberty to share.  Contact
your IBM rep and see if they can help you get access to a later version.
I don't think 9i was out at the time so this is likely an Oracle 8
migration tool.  Good luck!

R

> Hi ppl
>
> I have an existing b2c system on infinity server . i am planning to migrat
e it to websphere commerce server . Can any body suggest me some tools for o
racle database migration .
>
> Thanks
> Pravar

[ Post a follow-up to this message ]

Thanks Robert for your useful information . But situation here is we have an
 existing oracle system with infinity server and in the new implementation o
f WCS we are using still oracle as back end . But we want to convert our exi
sting database structure to
WCS compliant .We looked at couple of utilities like massloader but it is a 
time taking option for 20 mb of data it is taking 5 hrs which is too much an
d the second most important thing i want to figure out is the WCS DB structu
re. I looked at couple of
places but was not able to figure out the DB structure. Can you tell me wher
e can i find all the database information of WCS .

Thanks
Pravar

[ Post a follow-up to this message ]

Your request is easy.

Start with the data model from the InfoCenter:

WC v5.6.1
http://publib.boulder.ibm.com/infoc...fs/rdmindex.htm

WC v5.6.0.x
http://publib.boulder.ibm.com/infoc...fs/rdmindex.htm

I use this quite a bit (but assumes you know where the table might
exist) in the groupings IBM created.  If a table is not a hyperlink to
the detailed HTML it is usually there so click on another table and
change the table name to the one that doesn't link.

I would also recommend the last PDF version of the database tables
(v5.5) that provides a useful reference in one complete document.  Be
aware of the differences between your version and v5.5.

ftp://ftp.software.ibm.com/software...ema.pd
f

IBM never produced these PDFs for v5.6.x and we've asked for them.  The
InfoCenter is our bible now.

R

> Thanks Robert for your useful information . But situation here is we have an exist
ing oracle system with infinity server and in the new implementation of WCS we are u
sing still oracle as back end . But we want to convert our existing database structu
re
to WCS compliant .We looked at couple of utilities like massloader but it is
 a time taking option for 20 mb of data it is taking 5 hrs which is too much
 and the second most important thing i want to figure out is the WCS DB stru
cture. I looked at couple o
f places but was not able to figure out the DB structure. Can you tell me where can i find a
ll the database information of WCS .
>
> Thanks
> Pravar

[ Post a follow-up to this message ]

Thanks for the information robert . But here the scenario is quite different
 the migration is not happening between precious webspher commerce versions 
infatc it is happening from different ecommerce database to a new wcs system
 . Now we have information
for e.g., catologs,products or users and we want to migrate that information
 in wcs . Do you have any idea to go about it .

Thanks
Pravar

[ Post a follow-up to this message ]

Extract your data to xml format (csv is fine as well).  Then, write an
XSL to translate your data to WebSphere Commerce format.  From there you
can resolve any primary keys and load the data into the WC schema.  WC
provides tools to do this (look up txttransform, xmltransform, idresgen,
and massload).

I recommend you consult with an experienced WC architect who can assist
with the data migration.  That person can easily advise on which data
maps to an OOB table in WC or would be better suited to port to a new
custom table added to the existing WC schema.

<shameless plug>George Niece can sell you Dynaload too.</shameless plug>

R

> Thanks for the information robert . But here the scenario is quite different the m
igration is not happening between precious webspher commerce versions infatc it is h
appening from different ecommerce database to a new wcs system . Now we have informa
tio
n for e.g., catologs,products or users and we want to migrate that information in wcs . Do y
ou have any idea to go about it .
>
> Thanks
> Pravar

[ Post a follow-up to this message ]