| Author |
 Topic Search  Topic Options
|
ziv5 
Newbie
Joined: 23 November 2003
Location: Canada
Status: Offline
Points: 1
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Converting to MySQL: From Access or MSSQL
Posted: 23 November 2003 at 11:08pm |
Hi all,
I'm about to choose a ASP discussion forum. WebWiz and PD9's MegaBBS are the two forums I'm looking at.
I'm going to convert the forum to run MySQL since I need the performance and you cannot beat the cost. My question is, should I be converting the ASP from the Access version or from the MS SQL version of WebWiz? And for those that have done this code conversion before, how long did it take you?
This is going to run on MySQL v4.0.16 and MyODBC 3.51.06.
Really too bad WebWiz doesn't support MySQL. It is a top notch DB and is starting to get very popular with asp coders, as its getting lots of support from hosting providers.
Thank you,
-Ziv.
Edited by ziv5
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 6:22am |
|
If you are going to use MySQL use the Access code, the MSSQL code is built around stored procedures.
|
|
|
|
Tegwin
Senior Member
Joined: 03 September 2003
Location: United Kingdom
Status: Offline
Points: 430
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 7:04am |
I dont know if anyone has even tried this. I think that it will be quite complicated. The biggest problem will be with the coding of it to work with Mysql, to help you with the conversion, I have used some of these guys programs before, and they are pretty good.. http://www.convert-in.com/...
Let us know once you have done, it, perhaps you make it a mod
|
|
If you dont want my peaches, dont shake my tree
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 7:07am |
http://www.lodogg.com/upsizing.htm
Will this method work or is still upsizing the access code to the sql database? I'm not sure if this is the proper stored procedures after the upsize! Let me know!!
Thanks,
Lo
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 8:12am |
|
To convert Web Wiz Forums to run on mySQL will require the re-writting of almost every file and these around 140 of them.
Many of the SQL queries will need to be change.
Any updates that are done using ADO, which is most of them, will
require that these parts be completly re-written to use SQL updates and
as you don't have the security benefits of going through ADO you will
need to filter any user input used for these updates to remove any
malicious code that could be used for SQL injection.
I started re-coding the forum to run with mySQL, but gave up after
about 4 days and around 30 hours as I hadn't even scrathed the surface
and found that it would mean writting two different code bases as
changing the code for the acess and SQL server versions to make it more
compatible with mySQL lost performance and security.
I also found allot of problems with the myODBC driver.
I personally think that mySQL is better if you are using PHP, if you
are on a windows web server then you are better using ASP and MS SQL
Server.
|
|
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 9:25am |
So there is no easy way to upgrade from ACCESS to MSSQL? That sucks  If anyone comes up with a good way to upsize please let me know. I have a good 1000 posts and I want to upgrade my database but I wouldn't have a clue on how to re-write the code so there wouldn't be sql injections and what not  There's alot of people out there like me..... HELP 
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 9:27am |
Wait a second am I in na na land!! You are talking about mysql? Did my instructions above make sense-boRG-? From access to mssql?
God sorry for being an idiot!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2003 at 9:33am |
|
Sorry lodogg, I was continuing on the topic of this topic about mySQL
and converting web wiz forums to mySQL, you jumped in with a post which
was off-topic when you should have started a new topic.
The instructions you have given look very ggod, only problem I see is
that by running the SQL setup script will create double enties in the
database like second admin accounts with the default username and
apssword which could be hacked and also create double usergroups, etc.
All these would need to be erased if not could course a security risk.
|
|
|
|
