Commerce Server 2009 Data Migration-Collection of common programming errors

11 years ago
admin
2 minutes

  • msdn Hi, In our project we want to migrate the tables from Oracle system to Commerce Server 2009 database tables. If i use the Biztalk adapter , whether the task will be handy , meant automatically the business rules can we set to import data from Oracle system to CS 2009 DB.

    Please suggest me any other alternative for this data migration

    Thanks, Ramkumar

  • 6 Answers


  • msdn1

    Data porting can be easily achieved by using BizTalk adapters (I prefer to develop custom import tool using runtime API). Catalog and profile data (extra care in secure data fields like pwd, cc number, etc) can be easily migrated with limited effort but you should concentrate more on order data import (linked with multiple tables). Hope this helps.Regards,

    -Ravi Kanth 


  • msdn2 Hi Ravi, I want to import catalog , orders and Profile related data. Actually we are migrating our existing e commerce site (ASP & Oracle) to Commerce Server 2009 . So we have to migrate all the existing data present in Oracle  to Commerce server 2009 Catalog , order and Profile database tables. can we do this data Migration as doing with Other LOB application or do we need to take care of extra validation.

  • msdn3

    Data porting can be easily achieved by using BizTalk adapters (I prefer to develop custom import tool using runtime API). Catalog and profile data (extra care in secure data fields like pwd, cc number, etc) can be easily migrated with limited effort but you should concentrate more on order data import (linked with multiple tables). Hope this helps.Regards,

    -Ravi Kanth 


  • msdn4 Hi Ravi, We have decided to go with Biztalk adapter for data porting . Could you please tell me what version of Biztalk server do we need to get? because in MSDN there is tons of versions are there.

    The purpose is only for data migration. so please tell me the Biztalk server details


  • msdn5

    Ravi,

    Is SSIS and direct database inserts an option in particular in case of orders data?

    How to deal with the marshalled field?

    Please advise.


  • msdn6

    Ravi,

    Is SSIS and direct database inserts an option in particular in case of orders data?

    How to deal with the marshalled field?

    Please advise.

    I’ve been concerned about the issue, Got the workaround?