I just inherited a project where several sites are using an older 5.2 version of Web Wiz. I'm trying to reduce the database activity on these sites and notieced that the newer versions of Web Wiz are using stored procedures whereas the older version is not. So upgrading should help speed things up, but there seems to have been considerable change between the two database designs.
I doubt there is a migration script to make this big of a version jump, so I just want to get a feel for how hard it would be to write a script for migrating 5.2 data into a 7.96 version. I can see by looking at the tables that a lot of default values would have to be fabricated. For example, the Permissions and Category tables did not even exist before, and a Forum item needs a Category ID. If an Author item has no Permissions associated with it, does it break the code? The Group table did not exist before either. Is this migration feasible?
Probably only the Web Wiz designer can answer this, so hopefully you're reading this Bruce!
-Kyle
Topic Options
Post Options
Thanks(0)
