| Author |
Websphere commerce migration
|
|
|
| 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 oracle database migration .
Thanks
Pravar
| |
| Robert Brown 2006-01-13, 10:51 pm |
| 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 migrate it to websphere commerce server . Can any body suggest me some tools for oracle database migration .
>
> Thanks
> Pravar
| |
|
| Thanks Robert for your useful information . But situation here is we have an existing oracle system with infinity server and in the new implementation of WCS we are using still oracle as back end . But we want to convert our existing 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 and the second most important thing i want to figure out is the WCS DB structure. I looked at couple of
places but was not able to figure out the DB structure. Can you tell me where can i find all the database information of WCS .
Thanks
Pravar
| |
| Robert Brown 2006-01-13, 10:51 pm |
| 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...abaseSchema.pdf
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 existing oracle system with infinity server and in the new implementation of WCS we are using still oracle as back end . But we want to convert our existing 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 and the second most important thing i want to figure out is the WCS DB structure. 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 all the database information of WCS .
>
> Thanks
> Pravar
| |
|
| 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
| |
| Robert Brown 2006-01-24, 6:25 pm |
| 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 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 informatio
n 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
|
|
|
|