Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - V7 & V8 MSSQL Schema Differences
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

V7 & V8 MSSQL Schema Differences
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post Topic: V7 & V8 MSSQL Schema Differences
    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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.