This is an updated version of the migration tool for moving from BVC 2004.7 to BV Commerce 5.4 and 5.5. 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.

What if I am on BVC 2004.0? Sounds like I can't use this tool. I generated an email today which sent my version information to support asking the same question.

Aaron,

The import tool should match all related items. They will always come in as cross-sells because 2004 doesn't have an "up-sell" concept.

If you think the tool isn't functioning correctly some sample data for us to try and import would be helpful.

Thanks,
Marcus

Hah, I thought that was probably a bit confusing. My intended meaning was #2 (only one related assignment is imported and it is set as a cross sell).

Let me know how it goes for you. If you run into problems we did write a SQL script to do this import.

Yes, our script imports all 'Related Items' from BV 2004 to 'Cross Sells' in BV 5. Did the BV import tool work for you?

hey aaron, I'm willing to compensate you for that sql script.

For anyone else that is experiencing this problem, here is the script that I shared with Matt. This is provided as-is with absolutely no warranty, guarantee, etc. Be sure to backup your databases before running it. Before you run the script you will need to do a search/replace of the database names in the script. This script assumes that both your BV 2004 and BV 5 databases are on the same SQL Server. This isn't the most efficient query (it took about 5 minutes to run on a catalog of 3,000 SKU's), but that wasn't a priority when it was written (i.e. get it done ASAP since we will only run this once). Also note that this script deletes any Cross Sells from the BV 5 database that correspond to products in the 2004 database before importing the Related Items.

Hi,


I'm having a problem moving "Users" from a BVC2004 store to a new BV 5.8 store. Even when I re-ran the import tool selecting users only, the log shows the "Roles" as Skipping and then the "Starting Import Users" all are show as "not created"/



Has anyone else encountered this?



Thanks,



Jerry

Yes, that is likely the issue. I checked one of the old 2004 sites that we have lying around and it does have that table. That site was running 2004.7 (final release of 2004). Perhaps older versions of 2004 didn't have that table.

You could try running the SQL script below to create the table. That may help you get through the migration.

Sounds like it. You can check your version by going to Settings >> Version Information in the admin. Look at the version number of the BVSoftware.BVC.Core.dll file. If you have access to the various versions of 2004 you could always upgrade your site to 2004.7.Alternately we can continue to help you build out the missing or different tables.