Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Conversion from Snitz Access to WebWiz MySQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Conversion from Snitz Access to WebWiz MySQL

 Post Reply Post Reply Page  <123
Author
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2009 at 8:51am
Bruce, how come you offer a WWF version on mySQL, if you don't support it?  Surely when people buy a licence, it comes with 1 year of support - shouldn't the warning against mySQL be noted on the download page?

Quote mySQL is an excellent database for Web Wiz Forums. This version also includes the advanced paging found in the SQL Server 2005/2008 version and is able to cope with huge busy forums with ease.
Back to Top
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2009 at 9:12am
Originally posted by MortiOli MortiOli wrote:

Bruce, how come you offer a WWF version on mySQL, if you don't support it?  Surely when people buy a licence, it comes with 1 year of support - shouldn't the warning against mySQL be noted on the download page?
 
We decided to choose mySQL because every data manager told us it's terrific, and we decided to choose WebWiz as forum software because we knew it was possible to migrate from access to mySQL without loosing our previous data.
 
And the reason why we purchased a web hosted service with mySQL is this:
 
Originally posted by WebWiz-Bruce WebWiz-Bruce wrote:

Our hosting service offers the mySQL server version of Web Wiz Forums which works fine. The differences between mySQL and SQL Server wouldn't make much difference when using a forum application.
  
 
 


Edited by highinfidelity - 22 May 2009 at 1:03pm
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 May 2009 at 10:16am
mySQL is supported, if you read the post what is not supported is migrating a Web Wiz Forums database from Access or SQL Server to mySQL.

If you use mySQL from the start then no problem as the database will be created with a different non relational schema with different datatypes, and date handling and you have a database optimised for mySQL.

Access and SQL Server are both relational databases built by Microsoft that use a very similar schema and data types and Microsoft's Access Upsize wizard to SQL Server is excellent at upsizing the database.

The post that you bought up highinfidelity is from back 3 years ago just after the first mySQL version of web wiz forums was released. Since then have found that people who migrate to mySQL from SQL Server or Access versions of web wiz forums have allot of stability issues due to the very different schema used that can not be replicated accurately using conversion tools.

mySQL is a good database if on a budget or using Linux/PHP, but for ASP you can not beat SQL Server, and now that you have the free SQL Server Express Edition there isn't any real reason why you should choose the mySQL version, but then thats up to you.
Back to Top
highinfidelity View Drop Down
Newbie
Newbie


Joined: 22 April 2005
Location: Italy
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote highinfidelity Quote  Post ReplyReply Direct Link To This Post Posted: 01 June 2009 at 8:29am
I still don't get the point. The mySQL database actually IS the standard one in use by the WebWiz forum, it's only filled with text and numbers coming from another database by an automated .asp script. People could write the same things from their keyboards, only the way they're written there changes.
 
What if we lock all the threads coming from the old forum after the conversion? Would that fix these hypothetic issues? After all we don't need to have all those old topics still active, we'd just like to have them available as a memory of past discussions in the same place.
 
The reason why we don't go to SQL server as you suggest is obviously because the hosting is much more expensive and we will never be able to afford 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: 01 June 2009 at 10:59am
SQL Server is the recommend database to use and it not expensive. Our own hosting starts from just £4.99 per month and includes SQL Server 2008 databases. If your host isn't giving you SQL Server for free with your hosting pacakge, maybe it's time to look for an alternative.
Back to Top
 Post Reply Post Reply Page  <123

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.