The database version identifies the version of the internal database schema used by SystemWeaver. Each server version normally works with exactly one database version. Although not frequently, we do sometimes update the database version with a new SystemWeaver release. You will be informed of this as part of your upgrade delivery. This article describes how to update the database version. 


Prerequisites

  •  The SystemWeaver server is stopped
  •  Sole access to the database during update
  •  A backup copy of the database should a rollback be required
  • Server and database compatible version of the swDatabaseManager tool


Note: The swDatabaseManager application is not for general distribution and should only be used by an authorized system administrator.


Database Backup 

If you have been informed that the upgrade includes a database version update, before getting started, take a backup of the database. (See How to Back Up the Database


Sole Access to the Database

As noted in the Prerequisites, prior to getting started with the update, you will want to stop all servers, e.g., mirror server, slave server, main server, etc. (see Stopping and Starting a SystemWeaver Server) and clients. In other words, there should be no active sessions via swExplorer, swAdmin2, swArchitect clients nor the API. Once all servers are stopped and you have verified that there are no active sessions, proceed with the below steps.


In the Server directory, open the swDatabaseManager application.



Selecting the Database

On the Database tab, select the Type of database you are using and enter the database information in Select database.  


Examples


Database TypeExample
SQLiteC:\MyDatabases\swdb.sqlite
OracleThe TNS alias of the Oracle server. Refer to Oracle documentation for details on TNS.
MS SQL ServerSYS6|SQLDB-SYSWEAV-PRD

Verifying Current Database Version

Next, click Display info to confirm the current version of your database. The version will display in the log window to the right. In the below example, the database version is 1.42.



Updating the Version

When you are ready, click the Update v1.4X to v1.4X button as instructed in your upgrade delivery information. The version of the database that you selected has now been updated. The update will be confirmed in the log window.



Close the application.