Migrating Database from 2.2 MS2 to 2.3.3

[Cheepnis]

I have finally come to the conclusion that I need to do a fresh install of 2.3.3 and migrate over my heavily-modified 2.2 MS2 store instead of patching what I'm currently running in order to be compliant with new PHP and MySQL versions forced upon me by my host. I have looked all over the forum and in the text files on the new download, but I haven't found anything clear-cut about how I migrate the database and what I need to do when I encounter problems.

 

This creates a bit of a quandry for me, though. Will 2.3.4 give me all new headaches if I upgrad now? What about 3.0? any migration path in the works? If I have to completely rebuild my store from scratch, why wouldn't I just go to OpenCart or some other solution that seems quite a bit more modern? Or am I worrying for nothing?

 

One thing I can say, there has never been a better suppot forum than that provided by the OSC community! Thanks for your help in my migration attempts!

[Guest]

@@Cheepnis

 

There is NO 2.3.4 (currently) and v3.x is .....well, don't hold your breath.

 

Integrating your database requires a firm grasp of SQL and the ability/confidence to manipulate tables and cells should you have to.

 

 

 

 

Chris

[Cheepnis]

@@Cheepnis

Integrating your database requires a firm grasp of SQL and the ability/confidence to manipulate tables and cells should you have to.

 

Yes, this is a given.

What I am looking for is more details about migration than what seems to be the only answer ever given to similar questions on this topic: "You then migrate the database". I know I need to migrate it, but how?

 

Note that it's not just products that I need to migrate. It's customers, orders, products, categories, attributes, reviews, etc. etc., The whole thing.

 

I assume I first install 2.3.3, creating a new database, then modify the new database to match the settings from the 2.2 version?

Or do I just export the data from 2.2 and massage it within Excel and import it to the 2.3.3 (can it be that simple)?

 

I assume the former, in which case:

 

Do the new database tables need to be empty first? Which ones?

Do I have to check the structure of every table and every field or are there only certain ones that I need concern myself with?

How do I import/export structures to use WinMerge for comparisons?

If I negelect to create a table in the new database (because, for example, it was installed by a mod), will this cause fatal errors or will it just be ignored and import will continue without it?

How do I import data once the new database has been modified?

 

If it's the latter (massage the spreadsheet) method, where do I find the structure I need for every single field?

 

Also, I want to create the new store in a different folder than my existing store, but on the same domain, so I can create the new store without any downtime on the old store. Will I be able to do this and what do I need to do to make sure that they will both work at the same time?

 

Thanks for your time and effort helping me (and I presume others) with this!

[Guest]

@@Cheepnis

 

You would export your current database to your local machine, then.....open it with a text editor. Assuming you have matching tables, you then copy/paste each table into the SQL tab of PHPMYDMIN. You do this for categories, products, orders, etc etc

 

 

HOWEVER, you will NOT be able to import your customer tables. The customer passwords will not work in the v2.3.3 database. So, your customers will have to create new accounts on the new site. (SOMETIMES, this is incorrect, but in most cases, customers cannot be integrated)

 

 

Create your new store in a sub-directory until you are done, then move it to your active directory. www.yourdomain.com/newstore/ This will prevent downtime with your current store.

 

Chris

[Cheepnis]

So none of the table structures have changed at all since 2.2 MS2? I just paste this segment (for example) from the exported SQL dump into the new database at the top level SQL tab?:

 

INSERT INTO `products` (`products_id`, `products_quantity`, `products_model`, `products_image`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `products_ordered`) VALUES

(901, 999, 'ShowdownWill', 'Showdown at Williams Creek.jpg', 6.0000, '2006-09-25 10:35:26', '2006-09-25 10:36:07', NULL, 0.10, 1, 1, 6, 0),

(902, 999, 'StarPacker', 'Star Packer.jpg', 6.0000, '2006-09-25 10:36:54', '2006-09-25 10:38:37', NULL, 0.10, 1, 1, 6, 0),

(903, 999, 'TexasTerror', 'Texas Terror.jpg', 6.0000, '2006-09-25 10:38:50', '2006-09-25 10:40:18', NULL, 0.10, 1, 1, 6, 0);

 

Out of my 63 old tables, which ones should I be able to migrate? Are we just talking about products? What about orders, categories, attributes, reviews - especially considering that I can't migrate customers.

 

Isn't there a list of tables that are migratable and full instructions on how to do this? I certainly am not the only person attempting it... I'm not afraid of getting my hands dirty, but there must be a clear and wordy description somewhere considering how often this seems to be asked.

[Cheepnis]

What about using Cart2Cart ? Is it a waste of money or a good solution? I'm trying to go from 2.2 MS2 to 2.3.3. If this actually works well, it may be worth the cost - they claim to be able to migrate all customer info and orders.

[multimixer]

@@Cheepnis

 

ofCourse you can migrate customers and orders too. Regarding passwords, you can check the statement here

[Guest]

Is it possible to upgrade from MS2.2 to new version withouth bigger problems ? Or it is better to start using na new sotre or clean install. I do have some addons instaled.

[tgely]

Hi @@Luka123

 

Upgrade step by step the datatables. Follow the upgrade documentations. When you finish you can use v2.3.3 core on it, but you need your previous installed addons to install in the new core.

 

Some month later you can use v2.4 so you might decide what would you do.

[Cart2Cart Team]

Hello Cheepnis,

 

Cart2Cart supports both 2.2 and 2.3.3 osCommerce versions. So you can easily move necessary data within two versions.

Cart2Cart has a four years of data migration experience and thousands of satisfied customers. You can read testimonials that our clients leave to see what people talk about us.

In case if you have any questions please feel free to contact our Support Team. We will be happy to help you with data transfer.

 

Regards,

Cart2Cart Team.

[Dan Cole]

A new contribution was added recently that you might find useful. It gives you all the SQL updates needed to move from different versions of osC.

 

http://addons.oscommerce.com/info/8731

 

Dan

[suzgems1]

A new contribution was added recently that you might find useful. It gives you all the SQL updates needed to move from different versions of osC.

 

http://addons.oscommerce.com/info/8731

 

Dan

 

I downloaded that file Dan but it is only a SQL file. No documentation. Is that what you intended?

[Dan Cole]

@@suzgems1

 

Yup...that is what this thread was about...were you looking for something more?

[suzgems1]

I thought some documentation on how to use it, but I see now that there is an URL for the topic thread. I'll check it out, thank you.