The Release Notes state that the most up to date version of the upgrade instructions can be found via a Knowledgemase search for DB_Upgrade.txt
Thus: http://support.ipswitch.com/kb/WP-20050303-DM04.htm This KB article has a couple of updates to the information included with the release incarnation: 1) All 8 scripts are listed (see comment below). 2) There's now an explicit statement that running the VBS script requires that Windows Scripting Host (v5.6) be installed. Some users remove this WSH for security reasons. But note that the VBS script is not the only way to install: it's merely provided as a shortcut for running the individual SQL scripts 3) This comment is added: > The text files located in the DB Scripts directory are > required for upgrade operations and must be present for > database upgrade, ensure that BOTH that the complete > contents of the directory and the subdirectory are present. I hope this helps Mark Symons Ipswitch, Inc Augusta GA -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 10 March 2005 13:59 To: [email protected] Subject: RE: [WhatsUp Forum] no sqls connection after upgrade to sp1 The manual upgrade instructions are incomplete. I posted this in the forum. http://www.ipswitch.com/forums/shwmessage.aspx?forumid=14&messageid=5303 I am running my DB and console on separate systems. I decided to run the install manually instead of using the scripts. Under "Manually run the upgrade scripts:", #3 lists each script to run in order, but left out the last script that brings the DB version in line with the application version. 3. Using the SQL Server Query Analyzer, load, and then execute (F5), the following scripts in the order listed: 1 - upgrade_from_101206_to_102.sql 2 - upgrade_from_102001_to_102002.sql (Script updated in Step 2) 3 - upgrade_from_102002_to_102003.sql 4 - upgrade_from_102003_to_102004.sql 5 - upgrade_from_102004_to_102005.sql 6 - upgrade_from_102005_to_102102.sql 7 - upgrade_from_102102_to_102103.sql It left out 8 - upgrade_from_102103_to_102202.sql I also ran into an issue doing the replacement of the placeholder with my install directory. SQL came back with an error saying that it couldn't find the file. Anybody else run the scripts manually? After running the last script, it fired up. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Finbom Magnus Sent: Thursday, March 10, 2005 4:05 AM To: '[email protected]' Subject: SV: [WhatsUp Forum] no sqls connection after upgrade to sp1 Hi! Yes, I got this too. The problem is that the last sql-script fails to run. And it is not inluded in the guide on how to upgrade. I ran this script manually, restarted the servern and then it worked. Best regards Magnus Finbom IT-Engineer Lansforsakringar Skaraborg Bank and Insurance Radhusgatan 8 54129 Skovde Sweden phone +46(0)500 777065, gsm +46(0)708 717060, fax +46(0)500 777065 [EMAIL PROTECTED] http://www.lansforsakringar.se/skaraborg -----Ursprungligt meddelande----- Fr�n: Bernhard Buchreiter [mailto:[EMAIL PROTECTED] Skickat: den 10 mars 2005 12:27 Till: [email protected] �mne: [WhatsUp Forum] no sqls connection after upgrade to sp1 After upgrading WhatsUp Professional with the Service Pack1 I get an error-window: //------------------- Database connection error. Database version mismatch. Database version: 101206 Application version= 102202 //------------------- Any hints? Bernhard Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ ***************************************************************** This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this in error, you must not use or disseminate any information contained in it. Please send it back to the person who sent it to you and delete it from your system. This footnote also confirms that this e-mail message has been swept by Sybari's Antigen for the presence of computer viruses. However, we cannot guarantee that this trans- mission is virus free, nor can we guarantee that this e-mail is secure or error-free as information could be intercepted, corrupted, lost, destroyed, or arrive late or incomplete. J.D. Power and Associates therefore does not accept liability for loss or damage suffered as a result of this transmission or for any errors or omissions in the contents of this e-mail. ***************************************************************** Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
