V7 & V8 MSSQL Schema Differences
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=23182
Printed Date: 07 April 2026 at 8:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: V7 & V8 MSSQL Schema Differences
Posted By: kbannon
Subject: V7 & V8 MSSQL Schema Differences
Date Posted: 25 April 2007 at 11:47am
I tried searching but didn't find a solution.
Is there a complete list available of the MSSQL schema differences between Versions 7 and 8 of WWF?
My forum has been modified and I would rather alter the existing database than create a new one and import/export as it currently is edging towards 500MB (excl. logs).
Thanks
-------------
I don't suffer from insanity, I enjoy every minute of it.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 25 April 2007 at 2:12pm
There is a database upgrade tool on the download page, which will update your database schema to version 8 and populate the new fields.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: kbannon
Date Posted: 25 April 2007 at 2:52pm
But if there have been table mods these will need to be dumped first and I was hping to avoid that.
I suppose I'll have to do it!
-------------
I don't suffer from insanity, I enjoy every minute of it.
|
Posted By: WebWiz-Bruce
Date Posted: 25 April 2007 at 2:59pm
Maybe best if you make any database changes in future for mods to prefix them with 'mod' this way you can be sure that database upgrades will not be effected by any modifications you have made.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: kbannon
Date Posted: 25 April 2007 at 3:13pm
I know which columns I have added (no datatypes, etc were altered) but I was hoping to be able to compare the differences and if possible just rename the new tables (if necessary) and also add new columns, etc as needed.
It should be straight forward enough anyhow just following the script.
-------------
I don't suffer from insanity, I enjoy every minute of it.
|
|