Freigeben über

Updated: Commerce Server 2007 Migration

  • Artikel

We recently updated the Migration document to contain a section about Post Migration Data Management. This section describes the steps that you should perform to remove nonessential data after you complete the migration of your Commerce Server site. Use SQL Enterprise Manager (for SQL Server 2000) or SQL Server Management Studio (for SQL Server 2005) to remove any database tables, stored procedures or triggers that you no longer need..

 

Commerce Server 2007 Migration

Comments

  • Anonymous
    April 29, 2008
    Hi, I have profile/Order data stored in Microsoft Sql server 2005 which i wanted to migrate to Commerce server 2007. I have couple of approaches which are
  1. Using a DTS/SSIS package to commerce server profile/Order table
  2. Using Commerce server APIs via Webservices. Please advice me the best approach. Thanks, Anish Nair
  • Anonymous
    April 30, 2008
    For bulk update you would use the CSOLEDB and I have known customers who have used DTSSSIS for this purpose. The Web Services APIs are meant for single update. So, which is the best it really depends on your business rules. Just remember that once you use the bulk inset via CSOLEDB or DTSSSIS then any changes will not reflect on the site if the profile was cached on a server. The default cache time is 5 minutes. -Max