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

  New Posts New Posts RSS Feed - From MSSQL 2005 Express Editon to MySQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

From MSSQL 2005 Express Editon to MySQL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
MarioM View Drop Down
Newbie
Newbie


Joined: 21 June 2005
Location: Poland
Status: Offline
Points: 21 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MarioM Quote  Post ReplyReply Direct Link To This Post Topic: From MSSQL 2005 Express Editon to MySQL
    Posted: 22 January 2012 at 5:24pm
Hi

I need change a forum database&hosting and I wonder how migrate my forum from MS SQL2005ExpressEdition to MySQL.
Is there any tool help me to do it?

regards,
MarioM
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: 23 January 2012 at 11:41am
The SQL Server version uses a Relation Database, while the mySQL version does not.

mySQL also stores dates, bit types, and other data types in different ways to SQL Server.

If you wanted to move from SQL Server to mYSQL version you would need to start again with a clean install.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
markusfromgermany View Drop Down
Newbie
Newbie


Joined: 02 August 2011
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote markusfromgermany Quote  Post ReplyReply Direct Link To This Post Posted: 31 January 2012 at 8:34pm
I know, Bruce won't support migrating to mySQL from a microsoft database (MSSQL, Access), but there are many people who need this. Why? Starting with Access is the easiest way. Then the forum and community grows and you need to migrate to a bigger system.
 
So - if Bruce won't to this - perhaps the webwiz community start a guideline for doing this?
 
I think of starting with a clean mySQL installation - delete the keys - inserting existing data (export from access as excel and import from excel) and setting the keys again?
 
would this be possible?
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 February 2012 at 9:44am
If you start with Access as your forum grows you should upsize the database to SQL Server which is also an RDMS.

We have Web Wiz Forums running on our network with as many as 5 million posts using SQL Server, however we find those that use the mySQL version we often have to move to SQL Server due to database and performance issues at around 300,000 posts.

The myODBC driver required for ASP to talk to a mySQL database is also very buggy, we are forever trying to find work arounds to error caused by this driver. It causes all sorts of stability issues.

Access is fine as a desktop database, mySQL is fine with PHP, but with ASP you should be looking at using SQL Server. 

Most web hosts, like ourselves, offer SQL Server as standard with all hosting plans, so it is not that expensive these days to use SQL Server.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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.