| Author |
 Topic Search  Topic Options
|
michael 
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
 Posted: 21 March 2005 at 5:42pm |
|
I don't know if this is the only thing that needs changing, this is just the part of ADO. There is a possibility that other things need to be changed as well. Give it a try and see what errors it throws you when you made those changes. Should only be a couple hundred or so, so not too much work...
|
|
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Posted: 21 March 2005 at 5:48pm |
|
oh another thing you need to consider is dates in mySQL where it sucks big time. Maybe they changed it since but it used to screw up dates that have been inserted totally.
|
|
|
|
RAVALON
Groupie
Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
|
Posted: 22 March 2005 at 2:27pm |
i know data format for MySQL...is not a problem....
Michael....thank you very much for your answers.....
I will try to convert myself...i find a tool to convert immediately Access DB into a MySQL DB...it works very good !
I develop a little test script to test performance, and as i read in some 3rd part publications, MySql have straordinary velocity performance
Thak you to all.....for answer and for patience..!  |
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 22 March 2005 at 2:42pm |
|
Every page that uses ADO to update the database (about 40%) need to be
changed to use SQL update queries, you will also need to add in
security to prevent SQL injections etc. on these pages as ADO usually
handles this.
All pages that use recordset paging will also need to be changed and
completely re-written to use arrays, etc. instead. This would be quite
a few of the forums main pages (about 30% of files).
Anything else that is not supported by mySQL and myODBC will also need updating.
Queries that use sub queries may also need updating, but later versions of mySQL may support this now.
Allot of other queries will need to also be changed as the database
used is a relational database and mySQL is not a Relational Database
Management System.
You may also find allot of other inconsistencies.
I did look at making an mySQL version once before but gave up after
about 30 to 40 hours as it required a completely different code base
which would be to costly to support along side the Access/SQL server
version.
I estamemted to do it probably would take around 150 hours to complete,
not including testing and debugging, and would require almost a total
re-write of the forum engine file by file with almost every file
needing to be re-written.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Posted: 22 March 2005 at 2:48pm |
|
Also if you did undertake this, you would only be able to use the code
yourself as the Web Wiz Forums license agreement doesn't allow you to
redistribute the code, even if it is modified.
Web Wiz Forums is NOT a GPL license and is not open source free software.
There are no planes to additionally support a mySQL version due to the
complexities of having support and update 2 different code bases.
|
|
|
|
RAVALON
Groupie
Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
|
Posted: 22 March 2005 at 2:59pm |
i understand....thank you for your explanation...
So you've abandoned this idea definitively ?
|
|
RAVALON
Groupie
Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
|
Posted: 22 March 2005 at 4:04pm |
ah....only a correction....MySQL is a relational database....maybe you're not documented in last version of this powerful db.
|
|
RAVALON
Groupie
Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
|
Posted: 22 March 2005 at 4:07pm |
|
stay happy...i would translate this forum for support Mysql....but if i cannot redistribute, i don't redistribute....
|
|
Support for MySQL; want you ?