Importing previously exported repository data into Oracle Server Database step-by-step

TopTeam and Visual Use Case (VUC) repository data that has been previously exported using the TechnoSolutions Repository Export utility can be imported into Oracle Database. All data including, all Projects, Requirements, Use Cases, other Repository Objects, Trace Relationships, Tracking Items, user accounts, security and workflow configuration, etc. are imported into Oracle Repository Database Schema.

This article describes the step-by-step procedure for importing repository data that has been previously exported using the TechnoSolutions Repository Export utility (as *.eif and *.exp files) into Oracle Database.

• TopTeam Administrators
• Visual Use Case Administrators
• IT Support
• System Administrators
• Database Administrators

You should have the following in order to successfully import data into Oracle Database:

1. TopTeam/Visual Use Case Schema must already be installed on Oracle Database.
(This is automatically done as a part of the TopTeam Application Server for Oracle installation process)

2. You should have TechnoSolutions Repository Import/Export utility for Oracle Database available to you.
Or,
You should have the Username/Password for TechnoSolutions Customer Portal (access to Customer Portal is available only to licensed customers) in order to download the Export/Import utility.

3. Ensure that the Import/Export utility has Database Schema version compatibility with your existing repository Database Schema.
The Import/Export utility name contains its Database Schema compatibility range.
For example; TopTeam_Export-Import_Oracle_Db_Vrsn_2.8-3.4_06Nov07.zip file indicates that it is compatible with ALL Database Schema versions between 2.8 and 3.4.

4. Username and Password for TopTeam Database Schema (user account) Database on Oracle.

5. TopTeam/VUC repository Database Schema on Oracle must be the same version as the Database Schema version in the Export (*.eif) files. In other words, you can only import data from another repository which has the same exact Database Schema version as the destination database.

6. Any existing data in the TopTeam repository tables will be overwritten during the import process. Ensure that there is no data in TopTeam/Visual Use Case repository on the destination Oracle Database Schema.

Download the Oracle Server Database Import utility from TechnoSolutions Customer Portal (access to Customer Portal is available only to licensed customers).

Unzip this file into an empty folder on a computer that is capable of connecting to Oracle Database.
In other words, the computer should already have the required Oracle Database connectivity files (DLLs, etc.). If the computer has any Oracle Database Management utility installed on it, then the connectivity files are automatically installed along with it.

NOTE: If you can successfully connect to Oracle Database using SQL Plus or any other Oracle Database utility from this computer, you have all the appropriate files and configuration that is required for connecting to Oracle Database.

Ensure that TopTeam Application Server and TopTeam Web Server are stopped so that all access to TopTeam Database on Oracle Database is stopped before starting the import process.

Refer to following articles to stop:

• TopTeam Application Server – How to start and stop TopTeam Application Server
• TopTeam Web Server installed as Service Edition – How to stop TopTeam Web Application Server
• TopTeam Web Server installed as ISAPI Dll – How to start and stop TopTeam Web Website on IIS

NOTE: Ensure that you have stopped all access to the repository Firebird Database before starting the export.

1. Ensure that TopTeam Application Server has been stopped.
2. Ensure that TopTeam Web Server has been stopped.

Double-click on the exe file (ttmImpExp_<<…>>_Ora.exe) to run the utility.

The installer file name format is: TopTeamImpExp_<TopTeam Database Schema Version Required>_<database type>_<release date>.exe

E.g. ImpExp2.09_DBver_5.0-BatchSize50_Ora-22Feb2010.exe

In the example above:
5.0 – is the compatible TopTeam Database version.
ora – is the Import/Export utility for Oracle Database.
22Feb2010 – is the release date of the Import/Export utility.

After reading the License Agreement, choose “I accept...” to proceed with data Export/Import.

Choose the “Import Data” option to import exported data into Oracle Database Server.

Login to Oracle Database Schema having TopTeam repository (.i.e. a user account on which TopTeam repository is installed).

Browse to the location where the exported repository data files are placed. Extension of the export data file is .eif.

NOTE: The file must be an export from another TopTeam repository.

Click Next to start data import into Oracle Database.

Before the import operation, any existing data in TopTeam Database Schema will be deleted. Therefore, it is recommended to import the exported data into a new TopTeam Database Schema.

Click Import to start the import process.

Type “yes” to confirm that you would like to replace the contents of TopTeam/Visual Use Case repository in the target Oracle Database with the data from this import file.

NOTE: The import operation does NOT affect any other data/table other than the TopTeam/Visual Use Case repository tables. This import operation cannot be undone.

Ensure from the message on the window about successful import of data. Click “Finish“ to exit the wizard once the import operation is completed.

Review the Import Log file from the Log folder of this utility to ensure that no errors were reported during the import process.
There is a summary report generated at the end of the Log file.
If you see the word “ERROR” that means the import was not successful.

In case of an error, send the Log file to TechnoSolutions Support so that it can be verified.

NOTE: Run Text Indexer Service of TopTeam Application Server and perform Rebuild Indexes.
If this step is not done, you will not be able to search records using the full text search function of TopTeam Desktop App.

Exporting repository data from Firebird Database step by step
Migrating your repository from one database type to another database type
Importing previously exported repository data into SQL Server Database step by step
Exporting repository data from SQL Database step by step

Revised: September 7th, 2016