First,Forgive for my bad English
I wrote a ASP script (CNWWF_796TO80_MSSQLupdate.asp) for upgrading MS SQL database from version 7.x to version 8 beta1. I have tested with MS SQL 2000 Server.
You can download the script from
here
Update procedure:
1. Make sure you have a backup copy of your old database before proceeding.
3. Open forum8\includes\database_configuration.asp and edit the file.
4. Put CNWWF_796TO80_MSSQLupdate.asp file in the root of your forum folder (forum8\CNWWF_796TO80_MSSQLupdate.asp).
5. Run forum8\CNWWF_796TO80_MSSQLupdate.asp , the script will change the structure of the db and insert some required data.
6. After the script finishes, you will have a working v8 forum.
7. Probably you won't be able to see the forum titles on the main page especially as a guest. This is because the permissions system is changed.
You will need to examine and set group permissions on the forum administration area manually.
I have upgraded my v7.96 database successfully, hope it works for you too.