Converting to MySQL: From Access or MSSQL
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=7547
Printed Date: 07 April 2026 at 2:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Converting to MySQL: From Access or MSSQL
Posted By: ziv5
Subject: Converting to MySQL: From Access or MSSQL
Date Posted: 23 November 2003 at 11:08pm
|
Hi all, -Ziv. |
Replies:
Posted By: ljamal
Date 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. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Tegwin
Date 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/ - 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 |
Posted By: lodogg
Date Posted: 24 November 2003 at 7:07am
|
http://www.lodogg.com/upsizing.htm - 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 |
Posted By: WebWiz-Bruce
Date 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. ------------- 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: lodogg
Date 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
|
Posted By: lodogg
Date 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! |
Posted By: WebWiz-Bruce
Date 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. ------------- 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: lodogg
Date Posted: 24 November 2003 at 9:47am
|
See that the weird thing I didn't need to to run the script? I will make the changes to that html document and I will e-mail it to you. I just need to do the export and then have make the config change to the 'SQL_server_connection.asp' file and bam the site pulled up:) I was just double checking that I wasn't leading my self open for problems. I tested the forum and it's working great. I will go live in a few days.... http://www.lodogg.com/upsizing.htm - http://www.lodogg.com/upsizing.htm I updated it for you. |
Posted By: WebWiz-Bruce
Date Posted: 24 November 2003 at 9:49am
|
No, you still need to create the stored procedures, so you need to pull
the parts from the sql setup file that create the stored procedures
only.
------------- 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: lodogg
Date Posted: 24 November 2003 at 12:41pm
|
How would I do that? Just run the sql_setup? I tired that and it said the tables have already been created. But then I connected to the database and everything was working. I went into stored procedures under SQL administrator and I saw the files in place. Not sure if those are from the access conversion or if they were from the sql setup script.
thanks Lo |
Posted By: gavinc
Date Posted: 24 November 2003 at 2:35pm
|
I can't agree more. I'm only around half-way through the conversion and I don't want to think how many hours I've put in. Before anyone asks though. It's been impossible to make the changes in such a way that they could be made available as a MOD. There are far too many changes that need to be made to make this a viable option.
|
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 25 November 2003 at 9:00am
|
When I come to build the SQL server version I am thinking about maybe making an mySQL server version. I'm going to place all SQL queries in sepprate class the same with the connection string as well as any differences between databases so it should be simpler to port to any database. ------------- 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: ljamal
Date Posted: 25 November 2003 at 1:19pm
So this means that you will be optimizing the forum for SQL Server? I'll be the first in line to test that baby and give suggestions. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: WebWiz-Bruce
Date Posted: 25 November 2003 at 4:22pm
|
Sorry I ment ASP.NET version I'm won't be making any majour advancedments to the classic ASP version I will be moving onto ASP.NET The code base for Access and SQL srever will remain the same to make support simpler and the forum is already more optimised for SQL server by using different SQL queries and stored procedures. ------------- 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: ljamal
Date Posted: 25 November 2003 at 5:10pm
|
Not to derail this thread anymore than it already has been but without taking advantage of the ability to return multiple recordsets, you really aren't fully taking advantage of SQL Server.
Does your move to ASP.NET mean that 7.7 will the last ASP version and what do you propose to do with ASP.NET that isn't available at asp.net? ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: WebWiz-Bruce
Date Posted: 26 November 2003 at 3:37am
|
A few things will still be added to the ASP version but a version 8 probally won't happen. Version 8 will more than likly be the ASP.NET version. As ASP.NET is more powerful I'm hoping to add new features like not having to have cookies enabled, setting time off-set by GMT time, better security, etc. ------------- 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: ljamal
Date Posted: 26 November 2003 at 3:51am
|
Sorry, to hear that but good to know, since I will be developing an optimized SQL version for my web sites and have been putting off doing so due to the rapid release of new versions. There are so few good classic ASP forums (free or paid) and WWF is one of the best.
Unforunately, Microsoft has almost cornered the .NET forum market, hopefully WWF.net will maintain the same quality as the ASP version. GMT time will be a great addition. For a site that I'm currently working on, I have been making great use of the getUTCdate() function in SQL 2000 which returns GMT (UTC) time. Unfortunately, such a function does not exist in Access. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Paul Lush
Date Posted: 26 November 2003 at 5:39am
|
Im guessing that the huge difference between ASP and ASP.NET is going to mean a long wait for it? Are you intending on supporting the intregrated security model in it? I'm going to start work on converting 7.60 to Windows intergrated this week so Im hoping 7.7 isnt going to a big upgrade |
Posted By: WebWiz-Bruce
Date Posted: 27 November 2003 at 4:17am
|
7.7 has almost very file changed at the moment.
------------- 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: Paul Lush
Date Posted: 27 November 2003 at 4:21am
|
Stupid question but do you have any time scales for 7.7 and/or maybe something 7.x other than fixes to 7.7? With the recent flood of updates, Im putting off the Windows Integrated version |
Posted By: WebWiz-Bruce
Date Posted: 27 November 2003 at 4:52am
|
In the next week as it is also a security update, if a security bug is found new versions are released faster.
------------- 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: Joey805
Date Posted: 18 December 2003 at 1:01pm
|
Borg, what happens if you run the entire sql setup script and get some errors about the tables already being created. Would there be anything wrong with doing this? It seems to create all the stored procedures. The forum seems to run fine after. Is there any way you could make a copy of that script that just adds the stored procedures so we dont get the errors? |
Posted By: lodogg
Date Posted: 18 December 2003 at 1:14pm
|
No it's just saying YEAH there are table already here. It's just letting you know. But of course you already know this beacuse you imported them from access. The reason you have to run the sql setup is to setup the stored procedure in that database that you just imported. It would be nice to have a script to create the stored procedures rather than doing this work around.. Be Cool Lo
------------- Just trying to have some fun and learn in the process. http://www.lodogg.com - Come have Some Fun |