| Author |
 Topic Search  Topic Options
|
jimmyloh 
Newbie
Joined: 27 October 2008
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Migrating from SQL 2000 to SQL 2005
Posted: 27 October 2008 at 1:17am |
|
Hi,
I have an existing Forum that I want to migrate from SQL 2000 to SQL 2005. What are the steps that are involved. I have backed up and restore a copy on SQL 2005. However, I am getting an error message.
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:- common.asp
Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute
I have made the necessary correction on database server name, user id, user password and database name.
Can you help me troubleshooting this?
thanks
Jimmy
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2008 at 6:35am |
|
You have not mentioned how you migrated the data.
The only way to move the database from SQL Server 2000 to 2005 or 2008 and keep the existing database schema intact is to either detach and reattach the database and then change the compatibility level, or how I would suggest that you do this is to create a backup of the database (a .bak file) and then use this to restore the database on SQL Server 2005.
You should also download the SQL Server 2005 version of Web Wiz Forums.
|
|
|
|
jimmyloh
Newbie
Joined: 27 October 2008
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2008 at 10:51am |
|
Hi,
I did a backup and restore of the database. Where can I find out the version of WebWizForum that I am running? Also, how can I figure out if I need a WebWizforum for SQL 2005?
thanks,
Jimmy
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2008 at 1:05pm |
|
There should be a file called includes/version_inc.asp that will contain the version number you are running.
If you are running a version 9 then download the latest 9.53 SQL Server 2005 version, upload it to your website and then edit the file database/database_connection.asp to put in your SQL Server database connection details.
|
|
|
|
dougl
Groupie
Joined: 01 August 2007
Status: Offline
Points: 65
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 February 2009 at 4:33am |
Bruce,
I am sitting on SQL 2000 w/ 9.55 - going to SQL 2005 this weekend... are there a few specific files in the sql 2005 version that I can copy over?
|
|
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 February 2009 at 8:28am |
|
Just update the database/database_connection.asp file with that from the SQL Server 2005/2008 web wiz forums download. This is the only file that is different between the various versions.
|
|
|
|
