Post by tommyla » Sat Jun 04, 2011 2:29 pm

making it version neutral would make it easy to import a backup of a older database into a newer opencart version
would make it simpr to upgrade without using a upgrade script as well

Active Member

Posts

Joined
Wed Jul 22, 2009 9:49 pm
Location - Norway

Post by mberlant » Sun Jun 05, 2011 9:49 pm

It sure would... except for the fact that version upgrades often include database changes. You would be making a backup of "triangles" and trying to restore them into a database that needs to be filled with "pentagons". The new database would have no way of knowing which of your three triangle sides is to go into which three of the now-five pentagon slots, nor what to fill in for the two absent sides.

Let's take a ridiculous example. Suppose that the Product table's first field is "Model Number" and the fifth field is "Price". The developers decide that the database would be much more efficient if it were rearranged so that the first field is now "Price" and the fifth field is now "Model Number". If we simply performed a backup on the old product list and restored this list to the new store you would have model numbers in the Price field and prices in the Model Number field.

Upgrade scripts do that rearrangement work for us, making space in the appropriate places to receive the new information.

Please use proper English at all times, so that all members may understand you.


User avatar
Active Member

Posts

Joined
Sun Mar 13, 2011 8:33 pm
Who is online

Users browsing this forum: No registered users and 3 guests