Web Wiz Forums - Update SQL 7.51a to 7.7?

Print Page | Close Window

Update SQL 7.51a to 7.7?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11737
Printed Date: 09 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Update SQL 7.51a to 7.7?

Posted By: llmavll
Subject: Update SQL 7.51a to 7.7?
Date Posted: 08 September 2004 at 11:00pm

I've used WWF for quite awhile now but changed over from Access to SQL on version 7.51a. I now what to do the update to 7.7, is there any easy way, are the updates cumulitive?(sp?) Is there an update script for something like this.

Any help would be appriciated.

Thanks

Mav

Replies:

Posted By: dj air
Date Posted: 09 September 2004 at 5:42am

there is no update script.

you need to look in the version history and update the file within the updates.

you will also have to check if any stored procedures what been updated, i think it may only be .asp files that have been edited.

Posted By: llmavll
Date Posted: 14 September 2004 at 7:23pm

Can you just re-run the msSQL_server_setup.asp file, will that add the new tables needed and save the old ones and the database info?

How can I check if the "stored procedures" have been updated?

Any help is appriciated.

Cheers

Posted By: llmavll
Date Posted: 18 September 2004 at 11:48pm

*BUMP*

Surely someone knows how to do this?

Thanks in advance for any help.

Posted By: dj air
Date Posted: 19 September 2004 at 6:27am

i belive from v7.01 there was no database table work done.

there may have been a few stored procedures done.. you could gelete the stored procedure in the SQL database and then in the MSSQL_server_setup.asp file delete the section that create hte tables/relationships etc and just leave the stored procedures and then run the page again. which will create them and any alteration that have been made.

we must strongly recommend you upgrade to at least V7.8 .. if not V7.9 as there was a major security hole before this release.

yet again there has been no database work only .asp work.

for more details on the files that have been changed look in the version history file