| Author |
Topic Search Topic Options
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 3:10pm |
Info_Tech wrote:
Ok I get page cannot be displayed when I try to open msSQL_server_update.asp, what am I doing wrong? |
You need to start a new topic and include the actual error message, not just the IE generic page can not be displayed.
|
 |
Andersen
Groupie
Joined: 07 July 2002
Location: Denmark
Status: Offline
Points: 152
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2006 at 8:03pm |
Will the MsSQL database run directly under MySQL. I´m planning an upgrade here, and I might as well skip the MsSQL and go for MySQL insted. But I cant see anything which need to be converted etc.
Edited by Andersen - 28 March 2006 at 8:04pm
|
|
Greets
Andersen
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 March 2006 at 9:50am |
|
mySQL is very different to SQL Server.
There are tools available on the mySQL site for database conversion, but you would need to upgrade to the version 8 database first.
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 April 2006 at 2:18am |
|
Regards to the arcade mentioned
it uses the existing database structure and inserts new values.
i have almost changed the arcade to work with V8, i just need to do the arcade edit games page and a few bugs.
to upgrade the arcade the best way or way you can do it is to just change the names of the table prefixs of the V7 to the V8 prefix and add 2 fields to the author table and 1 to the Common.asp file.
as i said all you have to do is copy the tables over
|
 |
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 April 2006 at 5:36pm |
-boRg- wrote:
Please Note:- If you have modified your version 7.x database yourself you may need to un-modify the database inorder for this update to work. |
-boRg- wrote:
It all depends if the arcade mod uses table column names the same as those in the new database. |
I assume that it will only be a problem if we added a column with the same name as a column you are adding, correct? Will it leave our columns alone as long as they don't have the same name as yours?
|
|
|
 |
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 April 2006 at 7:59pm |
|
Another question: Will this tool upgrade from any version 7.x or is there a minimum version number (i.e. 7.5x)? Based on the name, I assume it supports everything from 7.0x to 7.9x. Am I correct? Or would I need to do multiple upgrades like we've had to do in the past?
|
|
|
 |
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 April 2006 at 11:06pm |
wistex wrote:
I assume that it will only be a problem if we added a column with the same name as a column you are adding, correct?
Will it leave our columns alone as long as they don't have the same name as yours?
|
That is correct, i had other columns, tables etc in my database and had no problems updating
|
|
Handyman man?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 April 2006 at 11:04am |
wistex wrote:
Another question: Will this tool upgrade from any version 7.x or is there a minimum version number (i.e. 7.5x)? Based on the name, I assume it supports everything from 7.0x to 7.9x. Am I correct? Or would I need to do multiple upgrades like we've had to do in the past?
|
It will work on all version 7.x databases as the tables and columns remained the same for all version 7.x databases.
|
 |