________________________________________________________________________________________________
Before you begin the migration process, make sure you are aware of any changes that may impact your usage of Unanet. Check out the New Features pages to see what's new with this release.
Before you begin migrating your Unanet version to 3.4, backup your properties directory [using default C:\] found in C:\Unanet\properties, in the event that the migration makes changes to these files. Do this by copying those files into a directory outside of the Unanet home directory.
You should remove your previous version of Unanet to have the old version out of the registry.
In My Computer, or from Start\Settings access the control panel. Go to the Add/Remove Programs icon and double click. Here you will see the version of Unanet that is installed on your machine. Highlight Unanet x.x and click the Add/Remove button. A Confirm File Deletion dialog box will pop up, at this point click to yes. Uninstall shield will remove all the files necessary to complete this procedure.
Now make sure that the Unanet home directory (c:\Unanet by default) is gone. Delete this directory if it is still there. If you have problems removing this directory, you may need to shut down your servlet engine (Jrun, Tomcat, etc.) or web server.
If you have not been directed to do so earlier, you can access the installation package from our Web site at: http://www.unanet.com -- click on the Support button (note: you do need to have a support login id to access the secured support area). Sign in to the Support site, and navigate to the Download area to locate the installation package for the appropriate release.
When asked to choose from install to hard disk or run from current location, it is your choice. However it seems to run fine when choosing run from current location. It will place those files into a temporary directory and delete them when it is through.
Wherever you had stored these files prior to the upgrade, you can now copy them in to the Unanet properties directory.
When migrating from version 3.3.x to 3.4.x, you must run a database migration script in order for your program to work. The migrate scripts come with your Unanet software and can be found in [Default C:\ ] C:\Unanet\database.
Note I: When migrating Unanet from an older version, e.g. 3.2 to the newest version, 3.4, all database scripts MUST be run in a consecutive fashion to keep the data inline. For example: unanet33migrate.sql then unanet34migrate.sql and so on.
Note II: You may see errors when running these scripts. You should have your DBA evaluate the errors and report anything he or she might suspect is a problem. Some types of errors will not effect the operation of your Unanet database (i.e. “can’t delete table abc, table was not there”). Others indicate a problem with the database (i.e. “can’t create table abc, tablespace has run out of extents”). If you do find a problem that you or your DBA suspects might need attention, or if you simply are not sure, contact the Unanet support staff and we’ll help identify and correct any issues you may be having. For this reason, we highly recommend that you save all of the output from the migration scripts.
Before you do anything to your database you must make sure that:
* Beginning with Unanet 3.3, we no longer support SQL Server 6.5. On the Properties / Option tab of your database, make sure the Compatibility Level is set to at least "Database compatibility level 70".
| # | What to do | Description |
| 1 | Back up your database! | Do this in case anything goes wrong with the migration. |
| 2 | Run unanet34migrate.sql |
In SQL Enterprise Manager, in the menu bar, go to tools. Click SQL query tool. Go to the open folder icon and then go to the migration script, unanet34migrate.sql by going through the Unanet\database\sqlserver path. Click onto unanet34migrate.sql and open it. You will see its contents in the query box. At that point, click onto the green arrow to run this script. |
| 3 | Review and save output | Please save the output from the script. You need to make sure there were NO errors encountered before you continue. By saving the output, you can email it to the Unanet support staff if you have any questions about specific errors you might have encountered. |
| 4 | Set permissions |
If you followed our directions when you initially created the database, then the unanet database will not have permissions on the new or modified database objects. You will need to set those permissions. SQL 7.0/2000 Instructions:Go to the SQL Enterprise Manager. In tools, access the SQL Server Query Analyzer. Make sure that you have the correct database selected in the DB drop down menu, to prevent possible corruption of other databases. Go to "Open Query File" and obtain the sqlpermissions.sql file, this is found in the Unanet directory, Unanet\database\sqlserver. Click on the sqlpermissions.sql file. Click open. Now go to the bottom of the file and find the line that starts with "grant_perms". Change the next two values to whatever your database name and login name are. If you installed the system using the defaults, you do not need to change these values. Click the green arrow. |
| # | What to do | Description |
| 1 | Back up your database! | Do this in case anything goes wrong with the migration. |
| 2 | Run unanet34migrate.sql | Open SQL Plus, login to the Unanet schema, and execute Unanet\database\sqlserver\unanet34migrate.sql. |
| 3 | Review and save output | Please save the output from the script. The migrate script will create a file called unanet34migrate.log which will be in the directory where you started SQL Plus. You need to make sure there were NO unexpected errors encountered before you continue. By saving the output, you can email it to the Unanet support staff if you have any questions about specific errors you might have encountered. |
Back to Installation Table of Contents
Copyright © 1998-2002 Computer
Strategies, Inc., All Rights Reserved.
Last revised: September 13, 2002.