| Author |
 Topic Search  Topic Options
|
gr8indianbear 
Groupie
Joined: 07 November 2002
Location: United States
Status: Offline
Points: 64
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: MySQL or MSSQL and conversion
Posted: 10 February 2003 at 8:37pm |
'm currently running the Access version of 6.34, and i want to upgrade to v7 in SQL. so i got a couple questions (prob repeats but it's the start of a new era...so to speak)
1. should i get the current WWForum v7 in SQL Server, or wait til the final one, and when will the final one be out (best guesstimate)?
2. is there a script or sumthin to convert my Access db to the SQL server db? if not it is possible to write my own...right...?
3. which is better MySQL or MSSQL? (I have access to both)
4. what are good db managers for either?
ok that's all. maybe i should have posted them seperatley...
|
 |
MadDog
Mod Builder Group
Joined: 01 January 2002
Status: Offline
Points: 3008
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 8:46pm |
just to let you know if you wanted to use MySQL you would have to rewrite must of the code cause MSSQL and MySQL are completly different.
As for an upgrade script im not sure anyone has made one for access to sql yet.
|
|
|
|
gr8indianbear
Groupie
Joined: 07 November 2002
Location: United States
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 9:01pm |
the code to create the tables is different? or the code to access the DB is different? or is it something mroe than that?
Ill probably stick with MSSQL then.
as for the upgrade script, i'm guessing all i'd have to do is read in the data from the Access DB, and write that to the corresponding table in the SQL Server DB. sounds simple enough...in theory...any one see any probs with that?
Edited by gr8indianbear
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:21pm |
He's wrong. You wouldn't have to rewrite most of the code at all.
There are a few minor changes in the SQL syntax used between the two (such as TOP and LIMIT)
Additionally, MySQL doesn't support Stored Procedures (yet) so you would have to port the queries used in the Access version.
Apart from that, a connection string or two, and that's pretty much it!
As for un upgrade script, thats a different process altogether. You would want to ensure the correct indexes are maintained, equivalent data-types, keys etc. all must be functional.
There are certain existing Wizards / Routines that can do this, however there always seems to be a couple of changes that aren't correctly made.
Good luck!
Cheers,
Andrew
Edited by Bunce
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
MadDog
Mod Builder Group
Joined: 01 January 2002
Status: Offline
Points: 3008
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:23pm |
Bunce,
Ive been moding the forum for almost a year now. I have tryed to convert the forum to MySQL, you would have to rewrite ALL the SQL in the forum, even ask borg.
|
|
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:42pm |
It doesn't really bother me what you've done. No offence, but I've browsed your own personal site and some of your 'articles' haven't given me absolute faith in your ability (http://www.maddogs-asp.com/forum/display_topic_threads.asp?ForumID=26&TopicID=434&ReturnPage=&PagePosition=1&ThreadPage=2)
Yes the SQL code needs to be altered for syntax that is not compatible wth both. I'm a DBA and have worked on both database systems and am aware of the differences.
Your comment above was:
"if you wanted to use MySQL you would have to rewrite must of the code cause MSSQL and MySQL are completly different."
..this is just plain wrong. Firstly its primarily only the SQL statements, and secondly, they're not completely different database systems at all.
Sorry if that sounded harsh but I don't believe in people posting overarching comments like these that aren't correct.
Cheers,
Andrew
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2003 at 10:45pm |
In answer to the original questions:
1) Wait until the final version of V7 is out. (Its still in Beta)
2) I believe there is (was) another thread on a mod being used for a database upgrade. Someone else may be able to help on that one.
3) MS SQL is more robust and has more features. However MySQL is free / open source and quite powerful given its source.
4) MSSQL has Enterprise Manager which comes with purchase, however there are a number of other (free) utilities out there that can be used. Additionally, Access 2000+ can be used to administer a MS SQL database through an ADP (Access Data Project)
MySQL has a couple of admin tools. Check out their site http://www.mysql.com for the latest.
Cheers,
Andrew
Edited by Bunce
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
IdEgoSuperEgo
Newbie
Joined: 15 February 2003
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 February 2003 at 11:08am |
|
I'm a newbie and need MUCH help. I had hosting on brinkster and my forum ran ok.I switched to yahoo hosting and I cannot access my forum. Yahoo supports mysql and php. How do I convert the forum to mysql? A link to a website tutorial or some advice would really be appreciated. Thanx
|
|
