Overview<\/h3>\n\nSome TopTeam<\/i> upgrades require that TopTeam Database<\/i> be upgraded to support the newest features.<\/p>\n
You can upgrade TopTeam Database Schema using the automated TopTeam Database Schema installer<\/i>. The TopTeam Database Schema installer<\/i> can be downloaded from the TechnoSolutions Customer<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\nThis article explains how to upgrade TopTeam Oracle Database Schema.<\/i><\/p>\n<\/div><\/div>\n\nWho should read this?<\/h3>\n\n\n- Database Administrators<\/li>\n
- TopTeam or Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n<\/ul>\n<\/div><\/div>\n\n
Preparations <\/h3>\n\n1. Find the TopTeam Database Schema<\/i> version currently installed in your organization. <\/strong>Refer to the article How to find TopTeam Database Schema Version<\/a>.<\/p>\n2. Find the version of TopTeam database Schema<\/i> that is required for the new version of TopTeam.<\/i><\/strong><\/p>\nYou can get this information from the release notes or upgrade instructions for the new release.<\/font>
\nYou need to upgrade TopTeam Database Schema<\/i> ONLY IF the database schema version required is greater than what is currently installed on your system.<\/p>\n3. Download the Oracle DB Schema Upgrade installer from the TechnoSolutions Customer Portal<\/a><\/strong> (access to Customer Portal is available only to licensed customers) or any other links provided to you.<\/strong><\/p>\nChoose the database schema upgrade installer based on your database type (SQL, Oracle or Firebird) and the TopTeam Database Schema<\/i> version required for the new version of TopTeam<\/i> that you want to upgrade to.<\/p>\n
The name of the installer indicates the database type and the database schema version to which it upgrades.
\nThe installer file name format is:<\/p>\n
TopTeam<Database Type><\/strong>DBSchemaUpgrade_<Upgrades from Version><\/strong>_to_<Upgrades To Version><\/strong>_<Release Date><\/strong>.exe
\nE.g. TopTeamORA<\/strong>DBSchemaUpgrade_2.9<\/strong>_TO_5.0<\/strong>_18Dec09<\/strong>.exe<\/p>\nHere,<\/p>\n
\n- ORA<\/strong> – indicates that this installer is for Oracle Database. Other possible values can be IB<\/strong><\/i> for Firebird and SQL<\/strong><\/i> for SQL Server.<\/li>\n
- 2.9<\/strong> – indicates that any TopTeam Oracle Database Schema<\/i> which is the same as or greater than version 2.9 can be upgraded using this installer.<\/li>\n
- 5.0<\/strong> – indicates that this installer will upgrade TopTeam Database Schema<\/i> to version 5.0.<\/li>\n
- 18Dec09<\/strong> – indicates the date on which the installer was released.<\/li>\n<\/ul>\n
You should choose the installer that satisfies the following conditions:<\/p>\n
\n- the <Database type><\/strong> of the installer should be ORA.<\/li>\n
- the <Upgrades from Version><\/strong> should be equal to or lower than the TopTeam Database Schema<\/i> version currently installed in your organization.<\/li>\n
- the <Upgrades to Version><\/strong> should be equal to the TopTeam Database Schema<\/i> version that you want to upgrade to.<\/li>\n<\/ul>\n
For example, if you want to upgrade your TopTeam Database<\/i> to version 5.4 and the TopTeam Database Schema<\/i> version currently installed on your system is 3.9 then, choose the installer which has ORA as <database type>, <Upgrades from Version> less than or equal to 3.9 and <Upgrades to Version> as 5.4 in its name.
\nE.g. TopTeamORADbSchemaUpgrade_2.9_to_5.4_<Any Release Date>.exe<\/p>\n
4. Identify “Oracle Database Schema for TopTeam” and ensure that you are able to connect to Oracle Database on the computer which will be running the upgrade installer.<\/strong><\/p>\n You much have the TopTeam Oracle Database Schema<\/i> credentials on that computer in order to connect.<\/p>\n<\/div><\/div>\n\nSystem Requirements for running the TopTeam Oracle Database Schema installer<\/h3>\n\nThe TopTeam Database Schema<\/i> installer runs on Windows computers.<\/p>\n
You must have the Oracle client libraries installed on the computer where the schema installer is to be run. Usually, the best computer to run the DB Schema installer is the computer on which TopTeam Application Server<\/i> is installed.<\/p>\n<\/div><\/div>\n\nIMPORTANT: STOP TopTeam Application Server and TopTeam Web Server<\/h3>\n\nStop ALL access to TopTeam Database<\/i>.<\/p>\n
Upgrading TopTeam Database<\/i> while the database is being accessed, can cause data inconsistencies.<\/p>\n
1. Stop TopTeam Application Server<\/strong><\/p>\n If your TopTeam Application Server<\/i> is running as a Windows Service, refer to the article How to start and stop TopTeam Application Server Service using Management Console<\/a>.
\n If your TopTeam Application Server<\/i> is installed as a Windows Application, refer to the article How to start and stop TopTeam Application Server when running as a Windows Application<\/a>.<\/p>\n2. Stop TopTeam Web Server<\/strong><\/p>\n If you are using TopTeam Web<\/i> IIS ISAPI edition then refer to the article How to start and stop TopTeam Web web site on IIS (version 7.x and below)<\/a>.
\n If you are using TopTeam Web Service<\/i> edition then refer to the article How to start and stop TopTeam Web Service<\/a>.<\/p>\n<\/div><\/div>\n\nStep 1. Run the Database Schema Upgrade installer<\/h3>\n\n![\"wpid17935-media_1269581218701-1.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
\n<\/div>\n<\/p><\/div>\n\nStep 2. Read and accept the License Agreement <\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 3. Click Next to run the TopTeam Database Schema upgrade wizard<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 4. The Oracle DB Schema Installer wizard opens<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 5. Backup TopTeam Database Schema before upgrading <\/h3>\n\n\n<\/div>\n\nIt is highly recommended that you backup the TopTeam Database<\/i> file before upgrading.<\/p>\n<\/div><\/div>\n\nStep 6. Connect to TopTeam Database Schema<\/h3>\n\n\n<\/div>\n\nYou must have the proper database privileges to proceed. <\/p>\n
Enter the Username<\/i> and Password<\/i> for Oracle Database Schema. Select the Database Name<\/i> where TopTeam Schema<\/i> exists.<\/p>\n<\/div><\/div>\n\nStep 7. View Scripts (Optional) <\/h3>\n\n\n<\/div>\n\nIf you wish to review the SQL commands in the upgrade, you can view them in this step.<\/p>\n<\/div><\/div>\n
\nStep 8. Run the TopTeam Database Schema upgrade<\/h3>\n\n\n<\/div>\n\nReview the Summary<\/i> and click Upgrade<\/i>.<\/p>\n<\/div><\/div>\n\nStep 9. Upgrading your TopTeam Database Schema<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 10. Installation is completed <\/h3>\n\n\n<\/div>\n\nYou have successfully upgraded TopTeam Database Schema.<\/i><\/p>\n
Click Finish<\/i> to exit the wizard.<\/p>\n
If an error occurs <\/i>during installation, you can restore TopTeam database using the backup file and send the Log File to TechnoSolutions support for investigation.<\/p>\n<\/div><\/div>\n\nLog File<\/h3>\n\n\n<\/div>\n\nThe Log File<\/i> is created in the following folder:<\/p>\n
C:\\…\\My Documents\\TechnoSolutions\\DB Schema Installer<\/strong><\/i><\/p>\nKeep a backup of this file for future reference.<\/p>\n<\/div><\/div>\n
\nStep 11. Finish to exit the wizard <\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nImportant<\/h3>\n\nYou need to optimize the server database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/p>\n<\/div><\/div>\n
Some TopTeam<\/i> upgrades require that TopTeam Database<\/i> be upgraded to support the newest features.<\/p>\n
You can upgrade TopTeam Database Schema using the automated TopTeam Database Schema installer<\/i>. The TopTeam Database Schema installer<\/i> can be downloaded from the TechnoSolutions Customer<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n This article explains how to upgrade TopTeam Oracle Database Schema.<\/i><\/p>\n<\/div><\/div>\n 1. Find the TopTeam Database Schema<\/i> version currently installed in your organization. <\/strong>Refer to the article How to find TopTeam Database Schema Version<\/a>.<\/p>\n 2. Find the version of TopTeam database Schema<\/i> that is required for the new version of TopTeam.<\/i><\/strong><\/p>\n You can get this information from the release notes or upgrade instructions for the new release.<\/font> 3. Download the Oracle DB Schema Upgrade installer from the TechnoSolutions Customer Portal<\/a><\/strong> (access to Customer Portal is available only to licensed customers) or any other links provided to you.<\/strong><\/p>\n Choose the database schema upgrade installer based on your database type (SQL, Oracle or Firebird) and the TopTeam Database Schema<\/i> version required for the new version of TopTeam<\/i> that you want to upgrade to.<\/p>\n The name of the installer indicates the database type and the database schema version to which it upgrades. TopTeam<Database Type><\/strong>DBSchemaUpgrade_<Upgrades from Version><\/strong>_to_<Upgrades To Version><\/strong>_<Release Date><\/strong>.exe Here,<\/p>\n You should choose the installer that satisfies the following conditions:<\/p>\n For example, if you want to upgrade your TopTeam Database<\/i> to version 5.4 and the TopTeam Database Schema<\/i> version currently installed on your system is 3.9 then, choose the installer which has ORA as <database type>, <Upgrades from Version> less than or equal to 3.9 and <Upgrades to Version> as 5.4 in its name. 4. Identify “Oracle Database Schema for TopTeam” and ensure that you are able to connect to Oracle Database on the computer which will be running the upgrade installer.<\/strong><\/p>\n You much have the TopTeam Oracle Database Schema<\/i> credentials on that computer in order to connect.<\/p>\n<\/div><\/div>\n The TopTeam Database Schema<\/i> installer runs on Windows computers.<\/p>\n You must have the Oracle client libraries installed on the computer where the schema installer is to be run. Usually, the best computer to run the DB Schema installer is the computer on which TopTeam Application Server<\/i> is installed.<\/p>\n<\/div><\/div>\n Stop ALL access to TopTeam Database<\/i>.<\/p>\n Upgrading TopTeam Database<\/i> while the database is being accessed, can cause data inconsistencies.<\/p>\n 1. Stop TopTeam Application Server<\/strong><\/p>\n If your TopTeam Application Server<\/i> is running as a Windows Service, refer to the article How to start and stop TopTeam Application Server Service using Management Console<\/a>. 2. Stop TopTeam Web Server<\/strong><\/p>\n If you are using TopTeam Web<\/i> IIS ISAPI edition then refer to the article How to start and stop TopTeam Web web site on IIS (version 7.x and below)<\/a>. It is highly recommended that you backup the TopTeam Database<\/i> file before upgrading.<\/p>\n<\/div><\/div>\n You must have the proper database privileges to proceed. <\/p>\n Enter the Username<\/i> and Password<\/i> for Oracle Database Schema. Select the Database Name<\/i> where TopTeam Schema<\/i> exists.<\/p>\n<\/div><\/div>\n If you wish to review the SQL commands in the upgrade, you can view them in this step.<\/p>\n<\/div><\/div>\n Review the Summary<\/i> and click Upgrade<\/i>.<\/p>\n<\/div><\/div>\n You have successfully upgraded TopTeam Database Schema.<\/i><\/p>\n Click Finish<\/i> to exit the wizard.<\/p>\n If an error occurs <\/i>during installation, you can restore TopTeam database using the backup file and send the Log File to TechnoSolutions support for investigation.<\/p>\n<\/div><\/div>\n The Log File<\/i> is created in the following folder:<\/p>\n C:\\…\\My Documents\\TechnoSolutions\\DB Schema Installer<\/strong><\/i><\/p>\n Keep a backup of this file for future reference.<\/p>\n<\/div><\/div>\n You need to optimize the server database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/p>\n<\/div><\/div>\nWho should read this?<\/h3>\n
\n
Preparations <\/h3>\n
\nYou need to upgrade TopTeam Database Schema<\/i> ONLY IF the database schema version required is greater than what is currently installed on your system.<\/p>\n
\nThe installer file name format is:<\/p>\n
\nE.g. TopTeamORA<\/strong>DBSchemaUpgrade_2.9<\/strong>_TO_5.0<\/strong>_18Dec09<\/strong>.exe<\/p>\n\n
\n
\nE.g. TopTeamORADbSchemaUpgrade_2.9_to_5.4_<Any Release Date>.exe<\/p>\nSystem Requirements for running the TopTeam Oracle Database Schema installer<\/h3>\n
IMPORTANT: STOP TopTeam Application Server and TopTeam Web Server<\/h3>\n
\n If your TopTeam Application Server<\/i> is installed as a Windows Application, refer to the article How to start and stop TopTeam Application Server when running as a Windows Application<\/a>.<\/p>\n
\n If you are using TopTeam Web Service<\/i> edition then refer to the article How to start and stop TopTeam Web Service<\/a>.<\/p>\n<\/div><\/div>\nStep 1. Run the Database Schema Upgrade installer<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 2. Read and accept the License Agreement <\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 3. Click Next to run the TopTeam Database Schema upgrade wizard<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 4. The Oracle DB Schema Installer wizard opens<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 5. Backup TopTeam Database Schema before upgrading <\/h3>\n
\n<\/div>\n
Step 6. Connect to TopTeam Database Schema<\/h3>\n
\n<\/div>\n
Step 7. View Scripts (Optional) <\/h3>\n
\n<\/div>\n
Step 8. Run the TopTeam Database Schema upgrade<\/h3>\n
\n<\/div>\n
Step 9. Upgrading your TopTeam Database Schema<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 10. Installation is completed <\/h3>\n
\n<\/div>\n
Log File<\/h3>\n
\n<\/div>\n
Step 11. Finish to exit the wizard <\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Important<\/h3>\n