| Author |
 Topic Search  Topic Options
|
MortiOli 
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: SQL 2000 to 2008
Posted: 16 July 2009 at 6:41pm |
Hi Bruce,
I'm looking to move my WWF install onto a 2008 version of MS SQL, from a 2000 install.
The process would be to move the database from a 2000 server to a 2008 server.
What would the steps be to move and upgrade my WWF database at the same time?
Cheers,
Oli
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 8:02am |
|
All you need to do is create a backup of the SQL Server 2000 database (.bak file), then restore this to the new SQL Server 2008. The database is then upgraded to SQL Server 2008.
To upgrade your forum have a look at the upgrade documentation at the link below:-
http://www.webwiz.net/webwizforums/kb/
|
|
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 8:31pm |
|
How do you force the forum to think that it's a new install, and needs to run the setup file again? Because you have to put the database connection settings in the asp file (an error is thrown if they're not correct), and because the new database already has WWF data in it, the forum thinks it doesn't need to run setup.
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 8:42pm |
|
With the new install instructionsyou do not edit the asp file with your connection settings. Thats what the upgrade does for you. Replace the default asp file and run the forum.
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 8:58pm |
That's what I thought when I first downloaded the upgrade, but it just said the db connection settings were incorrect:
Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_db_connection
File Name:- database_connection.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid authorization specification
|
Just removed them again, and tried, and the same thing happens.
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 9:05pm |
|
I would put the 9.6 asp files there and edit nothing. The upgrade wizard will work.
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 9:49pm |
|
They are 9.60 files - I'm basically moving (or test moving) my forum from one server to another, so I can change from SQL 2000 to SQL2008.
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 July 2009 at 10:20pm |
You asked "How do you force the forum to think that it's a new install..." I believe that if you use the standard 9.6 asp files and do not edit them at all the upgrade wizard will start instead of your home page and will ask you to enter database connection info and other stuff as documented. From what you say I am not convinced you are doing this to the absolute letter. You have entered and removed connection info and that's not the process...reinstall the asp pages...I can add nothing else.
|
|
