MySQL vs Access vs SQL Server
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=18490
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL vs Access vs SQL Server
Posted By: cmeurer
Subject: MySQL vs Access vs SQL Server
Date Posted: 23 February 2006 at 3:11am
|
How will MySQL perform in comparison to the other two?
I am hoping that it can handle 100+ concurrent users, and 10,000+ posts. Thoughts???
I read on the board that Access can only handle 20 concurrent. This board ROX by the way!!!!
Thanks ! cm
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 23 February 2006 at 11:09am
|
Access is just a simple flat file desktop database system and not really capable of running a forum system with more than a handful of users and is only support because it is cheap and simple to setup for novices. If I had my way I would like to drop support for Access altogether as it courses to many issues. SQL Server and mySQL are proper database systems and can both handle very large forums with ease. Even the cut down lite version of SQL Server (MSDE 2000) is able to handle large Web Wiz Forums as this site currently uses MSDE as it's backend for the entire site, with almost 100,000 forums posts, 8,000 members, and often over 600+ sessions on the site being handled by the on MSDE database. Access simply would be able to cope with this at all. ------------- 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: VBScript
Date Posted: 23 February 2006 at 4:18pm
|
cmeurer, I am currently developing an application that will convert MS Access Databases to mySQL so if you already have a forum DB on access you can convert it when I release this tool
------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: cmeurer
Date Posted: 24 February 2006 at 5:26am
| COOL. Will it convert from 7.97 Access to final 8 release MySQL? That means I can start my board NOW!! Woohooo....... ;-) |
Posted By: wistex
Date Posted: 24 February 2006 at 4:25pm
|
I'd like to have something that allowed me to convert from MS SQL to MySQL.
------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |
Posted By: VBScript
Date Posted: 25 February 2006 at 8:15am
|
At the moment the program will convert MS Access databases to MySQL. You can choose the table type and if you want to send the table dirrectly to the server/host or if you want it dumped to a *.sql. I will propably start re-coding and try and get MS SQL to MySQL ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: VBScript
Date Posted: 25 February 2006 at 8:48am
This is proving to be very difficult. For a tool like this to be developed it would be very costly. I will try and continue looking into MS SQL conversion but it isn't looking too good at the moment.  I might release the software that only does MS Access -> mySQL and if i receive donations continue onto making MS Access/mySQL/MS SQL to MS Access/mySQL/MS SQL ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
VBScript wrote:Posted By: WebWiz-Bruce
Date Posted: 27 February 2006 at 11:28am
|
The way I would look at doing it is first create the new MySQL database using the database setup file. Once the database is created write an ASP application that first disables Auto Number fields, then simply copies across the data from either Access or SQL Server, once complete alter the auto number fields back again. I've not actually tried this yet in practice, but I would guess this is the most practical way to do it. ------------- 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: VBScript
Date Posted: 27 February 2006 at 5:24pm
|
I am writing an application (EXE) to convery any MS Access Database to mySQL I hope to release in a few days. Unfortunatly, I have not had much luck with MSSQL ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: Meson
Date Posted: 28 February 2006 at 8:44am
| Access's export to ODBC dtabase features does a nice job of transering data between Access and MySQL. THe only bug that nees to be fixed is the boolean values as mySQL doesn't understand them, and some field size modifications. |
Posted By: RadioActiveLamb
Date Posted: 01 March 2006 at 12:14am
| Data transformation from MSSQL to MSAccess is very straight-forward. Once in MSAccess format, use your up-coming tool to transfer to MySQL. Since it is a one-time thing, I don't think too many people would be upset performing a 2-step process. |
Posted By: xeerex
Date Posted: 07 March 2006 at 1:17pm
|
Any success on the conversion tool from Access to MySQL yet? ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: VBScript
Date Posted: 07 March 2006 at 3:21pm
|
I hope to have it released within a week. It has taken quite a bit of research because I have never used mySQL before.
------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: xeerex
Date Posted: 07 March 2006 at 4:05pm
|
Thanks -- I've only played with mySQL so I'm in the same boat. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: VBScript
Date Posted: 08 March 2006 at 7:57pm
|
I have made quite a lot of progress since yesterday. I will be able to release on saturday or even late this friday if all goes to plan! Watch this space I will let you know A.S.A.P when it is ready to download. xeerex, thanks for the interest in the tool im creating ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: xeerex
Date Posted: 09 March 2006 at 1:20pm
|
=============
xeerex, thanks for the interest in the tool im creating
=============
No problem at all. I've got a migration to do for a WWG board and this could help me out tremendously. If you need bandwidth for the download or anything like that, let me know. I can help you out in that way - or even a small paypal donation. ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: VBScript
Date Posted: 09 March 2006 at 4:55pm
|
If you find it useful a paypal donation would be greatly appreciated. I will give more info on donations when I release.
------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: VBScript
Date Posted: 09 March 2006 at 6:00pm
|
Advanced DataBase Converter Ver 1 Release I have finish Advanced DataBase Converter which is a tool that will allow you to convert any MS Access database to mySQL. Simple download the zip file, read the Read Me file and then run setup.exe You can download Advanced DataBase Converter from:- http://www.James-R.co.uk - http://www.James-R.co.uk P.S: If you find this tool useful please donate (see the right hand side of the homepage. ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: JohnKn
Date Posted: 10 March 2006 at 6:19pm
|
Congratulations on completing your app VBScript. Does it just convert
Access to mySQL, or does it specifically convert WW 7.9x Access
databases to WW 8.0 mySQL databases? The db schema is different in v8
isn't it? If it just converts Access straight across to mySQL I'm afraid you may have wasted your time, there are many tools available to do that including many free mySQL admin tools such as dbmanager pro. |
Posted By: VBScript
Date Posted: 11 March 2006 at 4:07pm
|
This app converts an MS Access databse to mySQL. Yes I may have wasted my time. But I wanted to try and make my own app. When version 8 is close to release I will make an upgarde tool that will have the ability for the user to choose one of the following
------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: YaGMuR_PreNSi
Date Posted: 29 March 2006 at 6:14pm
|
Microsoft VBScript runtime error '800a0035' File not found /visit_entry.asp, line 134 VBScript http://www.james-r.co.uk/visit_entry.asp?EntryID=6 - http://www.james-r.co.uk/visit_entry.asp?EntryID=6------------- MSN and Mail admin@yagmurprensi.net My WWF: http://www.fatihaytekin.com" rel="nofollow - www.FatihAytekin.com |
Posted By: VBScript
Date Posted: 01 April 2006 at 6:25am
|
Link Fixed
------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: anim8
Date Posted: 11 April 2006 at 5:44pm
|
Hey james, Did you ever add that 7.9 to 8 option? Is it safe as it is? DBschema's and all. |