ZNode 5.0 to 5.1 upgrade package
I don't know if ZNode is unable or unwilling, but they have not provided a package for upgrading an existing 5.0 database to 5.1. They recommend that you purchase a copy of RedGate's SQL tools to do the upgrade.
If you don't want to shell out the $400 for SQL Compare, I have created an upgrade package using RedGate's SQL Packager. Just run it and point it at your 5.0 database and it should make all the 5.1 changes. Of course do this on a temp database and test it first.
One thing that you will need to do for the upgrade to work correctly is to delete all records from the ZNodeActivityLog table. Because of some schema changes to this table it is not able to be updated while keeping the data intact.
I've attached the upgrade package "ZNode_50_to_51_SQLUpgrade.exe" to this post, just remove the "_.txt" from the end of it to use it.
If you aren't comfortable running an unknown executable I've also attached the SQL scripts that can be used to upgrade the database as "ZNode_50_to_51_Upgrade_SQL_Schema_and_Data.zip", again remove the "_.txt" to use the file.
Josh
| Attachment | Size |
|---|---|
| ZNode_50_to_51_SQLUpgrade.exe_.txt | 488 KB |
| ZNode_50_to_51_Upgrade_SQL_Schema_and_Data.zip_.txt | 50.33 KB |
Znode 5.0 to 5.1 Storefront Upgrad Scipts
Actually we are going to be releasing a repackaging of the software that will have the script in the Maintenance folder (we also have some updates to the install guide). Here is a link to the official file that will be included with that package:
http://www.znode.com/downloads/5.1.0/v5.0.0_to_v5.1.0_Database_Upgrade.z...
As mentioned above, you should only run this on a database that has been backed up and you should test your application before deploying to production.
Just as an aside, the Red Gate software does offer a 30 day trial that works for converting databases. It is software well worth having for your tool box though.
Znode Administrator
email: support@znode.com
url: www.znode.com
Script Error
Hi Admin,
I downloaded the official upgrade script and get's a lot of errors on invalid columns. Also creating new databases does not work as I always get error. I use VS 2008 and sql 2008.
What could be wrong?
Upgrade Sript
The upgrade script should work on an unmodified 5.0 database. What kinds of errors are you getting?
Znode Administrator
email: support@znode.com
url: www.znode.com
Upgrade Script
Hi,
I decided to install Sql Server 2005 and the upgrade script works perfect. However, I kept getting an expected error when I try to add a new product and this is not the case with a fresh v5.1 Database installation
Upgrade Sricpt
My apologies! I did not notice you are using SQL Server 2008. We don't officially support 2008 yet. Not that it won't work but we don't have any official testing on this.
What kind of errors are you getting? One thing to check are the indexes on the SKU fields in the Product, AddOnValue and SKU tables. These are set to be unique in later versions of the database so could cause you some troubles when upgrading an old database.
Znode Administrator
email: support@znode.com
url: www.znode.com