*** Replaced by a newer version here: http://forums.bvcommerce.com/de...lt.aspx?f=84&m=62490




This is an updated version of the migration tool for moving from BVC 2004.7 to BV Commerce 5.4. This version was rewritten to work directly against databases, skipping the web services.

IMPORTANT: This version requires .net 3.5 to be installed.

USEAGE: Ideally, this tool would run directly on the SQL server where your live databases are located. Second best is on the same local network and the SQL server. Last best is remote.

INVENTORY OPTIONS: There is a new checkbox that you should use if you have disabled all inventory on your BVC 2004 store. The checkbox will make more your bvc5 store more efficient by choosing modifiers instead of choices during the import process. It will also guarantee non-inventory tracking products show up correctly on the new store.

I'm using 5.4.0.5 of the migration tool to migrate data from bvc 2004.7 to BVC5.4.0.5 and am getting errors that the line items are not being created. I have setup a demo version of BVc2004.7 with only 3 items/3 orders to test the migration. Anyone seen this?

Thanks,

Eric


Here's the errors:

===========================================================
Starting Import Orders
Starting At 4/13/2009 9:16:04 AM
Starting Convert,New Order is Converted,Skip Checks Done
Saving Order 101
Failed to add line item A121 0d13b6c3-0712-4e28-888e-ddac5237b42c
Starting Convert,New Order is Converted,Skip Checks Done
Saving Order 102
Failed to add line item GLOBE 9b496bc9-b815-49b8-b4a2-eec1de476d17
Failed to add line item A121 2f8d5f0b-e8ae-4ee3-b836-5f5bce15122b
Starting Convert,New Order is Converted,Skip Checks Done
Saving Order 103
Failed to add line item G1 eef72935-7483-49f9-8c21-fb91c8afe87a
Finished Import Orders-True
Finished At 4/13/2009 9:16:05 AM

Thanks Marcus.

I downloaded the latest version of the Migration tool, and found that it creates, some, but not all order lines. It looks like it is bombing out for order lines that have multiple packages. It is also not copying package information to BVC_OrderPackage.


Error Message for Order that has Multiple Packages:
Starting Convert,Import for Order failed with exception: System.InvalidOperationException: Sequence contains more than one element
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)
at MigrationTool.Tasks.ImportOrders.ConvertOldOrder(bvc_Order oldOrder, BVC2004DataContext context)
at MigrationTool.Tasks.ImportOrders.ProcessSingleOrder(bvc_Order oldOrder, BVC2004DataContext context, Boolean clearOrders, MigrationSettings s)

Did anyone ever resolve this issue? I am having the same problem trying to get some archive data in BV5. Only on orders with multiple packages... or at least it seems.