Database upgrade 7.0 Pre Release to 7.03

[airplaneguy]

My developer is working on a new version of our website and requests the SQL script to upgrade our database from 7.0 pre release to 7.03.

I've downloaded all the instructions and step up versions to upgrade from the pre release to 7.03, but he insists we don't want the features of 7.03, just the database needs to be upgraded and an SQL script will do that for us.

Does anyone have any help?

Thanks

[jmestep]

I can't imagine why he would think you wouldn't want the features, only a database upgrade, unless he is doing a lot of heavy customizations to take care of some of those features, including admin changes where the 7.0.3 code makes it so much nicer to place an order from the admin and you can search thru more objects like prododucs, users, categories.

[AbleMods]

There are significant structure changes in 7.0.3 that will break pre-release 7.0 code. Variants, taxes, even email templates are fundamentally changed in how they are managed and stored in the database.

Not to mention the hundreds and hundreds of fixes and improvements to the storefront as a whole.

Since the upgrade of the database is considered part of the upgrade to 7.0.3 itself, I don't think anyone is allowed to post portions of the upgrade in a public forum. Upgrades are part of the paid maintenance plan.

If you already have the upgrade files, you can find the SQL scripts in the ~/Install/ folder.

[keats76]

Good timing on this question ... I'm migrating a heavily customized 7.0 pre release to 7.03 as we speak. I started off with a fresh 7.0.3 install and now I'm merging in the customizations ... file comparison is very tedious, but necessary. I use a tool called WinMerge which is open source and freely used. I'm finally at the point where the new system compiles!!! Now I need to migrate data.

If I install the dataport utility on the 7.0 pre and export the database in xml format, will the 7.0.3 dataport handle my tax rules etc from the old instance properly?

Otherwise, all is going well.

Thanks!
Mike

[jmestep]

If your current site is Able 7, you don't need to use the dataport during an upgrade- Once you have your 7.0.3 files up for the site, then browse to the install/upgrade.aspx. The upgrade scripts make changes to the database that makes it correct for 7.0.3. If you use the dataport, all the data might not get transferred correctly and most likely your categories and product ids won't be the same. I tried the dataport with a move of a 7.0.3 site between two different hosters and it did renumber things. (If you are upgrading from an Able 5 store and moving data with the dataport, there is an option in the dataport to retain the numbering.)

[WylieE]

My developer is working on a new version of our website and requests the SQL script to upgrade our database from 7.0 pre release to 7.03.

I've downloaded all the instructions and step up versions to upgrade from the pre release to 7.03, but he insists we don't want the features of 7.03, just the database needs to be upgraded and an SQL script will do that for us.

Does anyone have any help?

Thanks

IMO, that seems like a very dangerous request. I would ask for a good explaination as to why he wants to do that.

Even if you have a heavily modified site you'd be missing all the other structure and code changes as has been mentioned. I can only imagine this would make future updates even more difficult and not a road I would recommend.

I hope your developer is properly documenting his code changes. That, along with Beyond Compare, has made our upgrades much, much easier.

[airplaneguy]

Thanks to all who replied. Our developer decided to run the 7.03 upgrade utility and he reports back that it upgraded the database as he wanted.

Quit laughing...

[AbleMods]

Quit laughing...

Too late