https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 20:15:14 +0000 Wed, 25 Apr 2007 15:13:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23182 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122321.html#122321 Author: kbannon
Subject: 23182
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.
]]> Wed, 25 Apr 2007 15:13:51 +0000 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122321.html#122321 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122320.html#122320 Author: WebWiz-Bruce
Subject: 23182
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.]]> Wed, 25 Apr 2007 14:59:33 +0000 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122320.html#122320 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122318.html#122318 Author: kbannon
Subject: 23182
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!]]> Wed, 25 Apr 2007 14:52:08 +0000 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122318.html#122318 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122316.html#122316 Author: WebWiz-Bruce
Subject: 23182
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.]]> Wed, 25 Apr 2007 14:12:38 +0000 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122316.html#122316 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122309.html#122309 Author: kbannon
Subject: 23182
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
]]> Wed, 25 Apr 2007 11:47:59 +0000 https://forums.webwiz.net/v7-v8-mssql-schema-differences_topic23182_post122309.html#122309