{"id":3877,"date":"2014-03-30T06:10:23","date_gmt":"2014-03-30T06:10:23","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/03\/30\/commerce-server-2009-data-migration-collection-of-common-programming-errors\/"},"modified":"2014-03-30T06:10:23","modified_gmt":"2014-03-30T06:10:23","slug":"commerce-server-2009-data-migration-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/03\/30\/commerce-server-2009-data-migration-collection-of-common-programming-errors\/","title":{"rendered":"Commerce Server 2009 Data Migration-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn 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.<\/p>\n<p>Please suggest me any other alternative for this data migration<\/p>\n<p>Thanks, Ramkumar<\/li>\n<li>\n<h3>6 Answers<\/h3>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn1<\/p>\n<p>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).\u00a0Hope this helps.Regards,<\/p>\n<p>-Ravi Kanth\u00a0<\/p>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn2 Hi Ravi, I want to import catalog , orders and Profile related data. Actually we are migrating our existing e commerce site (ASP &amp; Oracle) to Commerce Server 2009 . So we have to migrate all the existing data present in Oracle\u00a0 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.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn3<\/p>\n<p>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).\u00a0Hope this helps.Regards,<\/p>\n<p>-Ravi Kanth\u00a0<\/p>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn4 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.<\/p>\n<p>The purpose is only for data migration. so please tell me the Biztalk server details<\/p>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn5<\/p>\n<p>Ravi,<\/p>\n<p>Is SSIS and direct database inserts an option in particular in case of orders data?<\/p>\n<p>How to deal with the marshalled field?<\/p>\n<p>Please advise.<\/p>\n<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn6<\/p>\n<blockquote>\n<p>Ravi,<\/p>\n<p>Is SSIS and direct database inserts an\u00a0option in particular in case of orders data?<\/p>\n<p>How to deal with the marshalled field?<\/p>\n<p>Please advise.<\/p>\n<\/blockquote>\n<p>\nI&#8217;ve been concerned about the issue, Got the workaround?<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3877","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/3877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=3877"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/3877\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=3877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=3877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=3877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}