Web Wiz Forums - Migrating data from version 5.2 to 7.96

Print Page | Close Window

Migrating data from version 5.2 to 7.96

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17133
Printed Date: 16 April 2026 at 6:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Migrating data from version 5.2 to 7.96

Posted By: passfire
Subject: Migrating data from version 5.2 to 7.96
Date Posted: 03 November 2005 at 10:08pm

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