|
| | | Supreme Being
Group: Forum Members
Last Login: 9/28/2005 11:33:00 AM
Posts: 128, Visits: 1 |
| I am running my DB and console on seperate 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 th 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. |
| |
| | | Junior Member
Group: Forum Members
Last Login: 3/11/2005 5:43:00 PM
Posts: 14, Visits: 1 |
| As per post also made to email forum...
The Release Notes state that the most up to date version of the upgrade instructions can be found via a Knowledgebase 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.
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 |
| |
|
|