Overview <\/h3>\n\nTopTeam<\/i> and Visual Use Case (VUC)<\/i> repository data that has been previously exported using the TechnoSolutions Repository Export utility<\/i> can be imported into Oracle Database<\/i>. All data including, all Projects, Requirements, Use Cases, <\/i>other Repository Objects, Trace Relationships, Tracking Items,<\/i> user accounts, security and workflow configuration, etc. are imported into Oracle Repository Database Schema<\/i>.<\/p>\n
This article describes the step-by-step procedure for importing repository data that has been previously exported using the TechnoSolutions Repository Export utility<\/i> (as *.eif <\/i>and *.exp<\/i> files) into Oracle Database.<\/i><\/p>\n<\/div><\/div>\n\nWho should read this? <\/h3>\n\n\n- TopTeam Administrators<\/li>\n
- Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n
- System Administrators<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div><\/div>\n\n
Process Concept Diagram <\/h3>\n\n![\"wpid28369-media_1282587847242.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
\n<\/div>\n<\/p><\/div>\n\nPreparations<\/h3>\n\nYou should have the following in order to successfully import data into Oracle Database<\/i>:<\/p>\n
1. TopTeam\/Visual Use Case Schema<\/i> must already be installed on Oracle Database<\/i>.
\n (This is automatically done as a part of the TopTeam Application Server for Oracle <\/i>installation process) <\/p>\n
2. You should have TechnoSolutions Repository Import\/Export utility<\/i> for Oracle Database available to you.
\n <\/strong>Or,
\n You should have the Username\/Password for TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers<\/font>) in order to download the Export\/Import utility.<\/i><\/p>\n3. Ensure that the Import\/Export utility<\/i> has Database<\/i> Schema version compatibility with your existing repository Database Schema.
\n The Import\/Export utility <\/i>name contains its Database Schema compatibility range.
\n For example; TopTeam_Export-Import_Oracle_Db_Vrsn_2.8-3.4_06Nov07.zip<\/strong> file indicates that it is compatible with ALL Database Schema versions between 2.8 and 3.4.<\/p>\n4. Username and Password for TopTeam Database Schema (user account) Database on Oracle.<\/p>\n
5. TopTeam\/VUC<\/i> repository Database Schema on Oracle must be the same version as the Database Schema version in the Export (*.eif<\/i>) files. In other words, you can only import data from another repository which has the same exact Database Schema version as the destination database.<\/p>\n
6. Any existing data in the TopTeam <\/i>repository tables will be overwritten during the import process. Ensure that there is no data in TopTeam\/Visual Use Case<\/i> repository on the destination Oracle Database Schema.<\/i><\/p>\n<\/div><\/div>\n\nStep 1. Download the Oracle Server Database Import utility<\/h3>\n\nDownload the Oracle Server Database Import<\/i> utility from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div><\/div>\n\nStep 2. Unzip the Import utility<\/h3>\n\nUnzip this file into an empty folder on a computer that is capable of connecting to Oracle Database. <\/i>
\nIn other words, the computer should already have the required Oracle<\/i> Database<\/i> connectivity files (DLLs, etc.). If the computer has any Oracle Database Management <\/i>utility installed on it, then the connectivity files are automatically installed along with it.<\/p>\n
NOTE: <\/strong>If you can successfully connect to Oracle Database<\/i> using SQL Plus<\/i> or any other Oracle Database <\/i>utility from this computer, you have all the appropriate files and configuration that is required for connecting to Oracle Database.<\/i><\/p>\n<\/div><\/div>\n\nStep 3. Stop TopTeam Application Server and Web Server<\/h3>\n\nEnsure that TopTeam Application Server<\/i> and TopTeam Web Server<\/i> are stopped<\/strong><\/i> so that all access to TopTeam Database on Oracle Database is stopped before starting the import process<\/strong><\/i>.<\/p>\nRefer to following articles to stop: <\/font><\/p>\n\n- TopTeam Application Server <\/font><\/strong>– <\/font>How to start and stop TopTeam Application Server<\/a> <\/li>\n
- TopTeam Web Server<\/font> installed as Service Edition –<\/font><\/strong> <\/font>How to stop TopTeam Web Application Server<\/a><\/li>\n
- TopTeam Web Server installed as ISAPI<\/strong> Dll<\/strong> – How to start and stop TopTeam Web Website on IIS<\/a><\/li>\n<\/ul>\n
NOTE: <\/font><\/strong>E<\/font>nsure that you have stopped all access to the repository Firebird Database<\/i> before starting the export.<\/p>\n\n- Ensure that TopTeam Application Server<\/i> has been stopped.<\/li>\n
- Ensure that TopTeam Web Server<\/i> has been stopped.<\/li>\n<\/ol>\n<\/div><\/div>\n\n
Step 4. Run the TopTeam Import utility<\/h3>\n\nDouble-click on the exe<\/strong> file (ttmImpExp_<<…>>_Ora.exe) to run the utility.<\/p>\nThe installer file name format is: TopTeamImpExp_<TopTeam Database Schema Version Required><\/strong>_<database type>_<release date><\/strong>.exe<\/p>\nE.g. ImpExp2.09_DBver_5.0-BatchSize50_Ora-22Feb2010.exe<\/p>\n
In the example above:
\n5.0<\/strong> – is the compatible TopTeam Database<\/i> version.
\nora –<\/strong> is the Import\/Export utility <\/i>for Oracle Database.<\/i>
\n22Feb2010 <\/strong>– is the release date of the Import\/Export utility.<\/i><\/p>\n<\/div><\/div>\n\nStep 5. Welcome screen for Data Export\/Import Wizard for Oracle displays<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 6. Accept the License Agreement <\/h3>\n\n\n<\/div>\n\nAfter reading the License Agreement, choose “I accept..<\/strong><\/i>.<\/strong>” to proceed with data Export\/Import.<\/p>\n<\/div><\/div>\n\nStep 7. Choose an operation<\/h3>\n\n\n<\/div>\n\nChoose the “Import Data<\/i>” option to import exported data into Oracle Database Server<\/i>.<\/p>\n<\/div><\/div>\n\nStep 8. Login to the database<\/h3>\n\n\n<\/div>\n\nLogin to Oracle Database<\/font> Schema<\/i> having TopTeam repository<\/i> (.i.e. a user account on which TopTeam <\/i>repository is installed).<\/p>\n<\/div><\/div>\n\nStep 9. Select the exported file path<\/h3>\n\n\n<\/div>\n\nBrowse to the location where the exported repository data files are placed. Extension of the export data file is .eif<\/strong>.<\/i><\/p>\nNOTE:<\/strong> The file must be an export from another TopTeam <\/i>repository.<\/p>\n<\/div><\/div>\n\nStep 10. Review Data Import Summary<\/h3>\n\n\n<\/div>\n\nClick Next<\/strong><\/i> <\/strong>to start data import into Oracle Database<\/i>.<\/p>\n<\/div><\/div>\n\nStep 11. Start the import operation<\/h3>\n\n\n<\/div>\n\nBefore the import operation, any existing data in TopTeam Database Schema<\/i> will be deleted. Therefore, it is recommended<\/strong><\/i> to import the exported data into a new TopTeam Database Schema<\/i>.<\/p>\nClick Import<\/i> <\/strong>to start the import process.<\/p>\n<\/div><\/div>\n\nStep 12. Delete Confirmation<\/h3>\n\n\n<\/div>\n\nType “yes<\/i>” to confirm that you would like to replace the contents of TopTeam\/Visual Use Case<\/i> repository in the target Oracle Database<\/i> with the data from this import file.<\/p>\n
NOTE:<\/strong> The import operation does NOT affect any other data\/table other than the TopTeam\/Visual Use Case<\/i> repository tables. This import operation cannot be undone.<\/p>\n<\/div><\/div>\n\nStep 13. Monitor data import<\/h3>\n\n\n<\/div>\n\nEnsure from the message on the window about successful import of data. Click “Finish<\/i>“<\/strong> to exit the wizard once the import operation is completed.<\/p>\n<\/div><\/div>\n\nStep 14. Review the Import Log file <\/h3>\n\n\n<\/div>\n\nReview the Import Log file from the Log folder of this utility to ensure that no errors were reported during the import process.
\nThere is a summary report generated at the end of the Log file.
\nIf you see the word “ERROR<\/strong>” that means the import was not successful.<\/p>\nIn case of an error, send the Log file to TechnoSolutions Support <\/i>so that it can be verified.<\/p>\n<\/div><\/div>\n\nStep 15. Post TopTeam Database Import step<\/h3>\n\nNOTE: <\/strong>Run Text Indexer Service of TopTeam Application Server <\/i>and perform Rebuild Indexes<\/strong>.<\/i>
\nIf this step is not done, you will not be able to search records using the full text search function of TopTeam<\/i> Desktop App<\/i>.<\/p>\n<\/div><\/div>\n\nSee Also<\/h3>\n\nExporting repository data from Firebird Database step by step<\/a>
\nMigrating your repository from one database type to another database type<\/a>
\nImporting previously exported repository data into SQL Server Database step by step<\/a>
\nExporting repository data from SQL Database step by step<\/a><\/p>\n<\/div><\/div>\n\n\nRevised: September 7th, 2016<\/p>\n<\/div><\/div>\n<\/p><\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview 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. Who should read this? TopTeam Administrators Visual Use Case Administrators IT Support System Administrators Database Administrators <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,45,46,7,295],"class_list":["post-2358","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-import","tag-oracle","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-C2","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2358"}],"version-history":[{"count":11,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358\/revisions"}],"predecessor-version":[{"id":46745,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358\/revisions\/46745"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2358"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
TopTeam<\/i> and Visual Use Case (VUC)<\/i> repository data that has been previously exported using the TechnoSolutions Repository Export utility<\/i> can be imported into Oracle Database<\/i>. All data including, all Projects, Requirements, Use Cases, <\/i>other Repository Objects, Trace Relationships, Tracking Items,<\/i> user accounts, security and workflow configuration, etc. are imported into Oracle Repository Database Schema<\/i>.<\/p>\n
This article describes the step-by-step procedure for importing repository data that has been previously exported using the TechnoSolutions Repository Export utility<\/i> (as *.eif <\/i>and *.exp<\/i> files) into Oracle Database.<\/i><\/p>\n<\/div><\/div>\n You should have the following in order to successfully import data into Oracle Database<\/i>:<\/p>\n 1. TopTeam\/Visual Use Case Schema<\/i> must already be installed on Oracle Database<\/i>. 2. You should have TechnoSolutions Repository Import\/Export utility<\/i> for Oracle Database available to you. 3. Ensure that the Import\/Export utility<\/i> has Database<\/i> Schema version compatibility with your existing repository Database Schema. 4. Username and Password for TopTeam Database Schema (user account) Database on Oracle.<\/p>\n 5. TopTeam\/VUC<\/i> repository Database Schema on Oracle must be the same version as the Database Schema version in the Export (*.eif<\/i>) files. In other words, you can only import data from another repository which has the same exact Database Schema version as the destination database.<\/p>\n 6. Any existing data in the TopTeam <\/i>repository tables will be overwritten during the import process. Ensure that there is no data in TopTeam\/Visual Use Case<\/i> repository on the destination Oracle Database Schema.<\/i><\/p>\n<\/div><\/div>\n Download the Oracle Server Database Import<\/i> utility from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div><\/div>\n Unzip this file into an empty folder on a computer that is capable of connecting to Oracle Database. <\/i> NOTE: <\/strong>If you can successfully connect to Oracle Database<\/i> using SQL Plus<\/i> or any other Oracle Database <\/i>utility from this computer, you have all the appropriate files and configuration that is required for connecting to Oracle Database.<\/i><\/p>\n<\/div><\/div>\n Ensure that TopTeam Application Server<\/i> and TopTeam Web Server<\/i> are stopped<\/strong><\/i> so that all access to TopTeam Database on Oracle Database is stopped before starting the import process<\/strong><\/i>.<\/p>\n Refer to following articles to stop: <\/font><\/p>\n NOTE: <\/font><\/strong>E<\/font>nsure that you have stopped all access to the repository Firebird Database<\/i> before starting the export.<\/p>\n Double-click on the exe<\/strong> file (ttmImpExp_<<…>>_Ora.exe) to run the utility.<\/p>\n The installer file name format is: TopTeamImpExp_<TopTeam Database Schema Version Required><\/strong>_<database type>_<release date><\/strong>.exe<\/p>\n E.g. ImpExp2.09_DBver_5.0-BatchSize50_Ora-22Feb2010.exe<\/p>\n In the example above: After reading the License Agreement, choose “I accept..<\/strong><\/i>.<\/strong>” to proceed with data Export\/Import.<\/p>\n<\/div><\/div>\n Choose the “Import Data<\/i>” option to import exported data into Oracle Database Server<\/i>.<\/p>\n<\/div><\/div>\n Login to Oracle Database<\/font> Schema<\/i> having TopTeam repository<\/i> (.i.e. a user account on which TopTeam <\/i>repository is installed).<\/p>\n<\/div><\/div>\n Browse to the location where the exported repository data files are placed. Extension of the export data file is .eif<\/strong>.<\/i><\/p>\n NOTE:<\/strong> The file must be an export from another TopTeam <\/i>repository.<\/p>\n<\/div><\/div>\n Click Next<\/strong><\/i> <\/strong>to start data import into Oracle Database<\/i>.<\/p>\n<\/div><\/div>\n Before the import operation, any existing data in TopTeam Database Schema<\/i> will be deleted. Therefore, it is recommended<\/strong><\/i> to import the exported data into a new TopTeam Database Schema<\/i>.<\/p>\n Click Import<\/i> <\/strong>to start the import process.<\/p>\n<\/div><\/div>\n Type “yes<\/i>” to confirm that you would like to replace the contents of TopTeam\/Visual Use Case<\/i> repository in the target Oracle Database<\/i> with the data from this import file.<\/p>\n NOTE:<\/strong> The import operation does NOT affect any other data\/table other than the TopTeam\/Visual Use Case<\/i> repository tables. This import operation cannot be undone.<\/p>\n<\/div><\/div>\n Ensure from the message on the window about successful import of data. Click “Finish<\/i>“<\/strong> to exit the wizard once the import operation is completed.<\/p>\n<\/div><\/div>\n Review the Import Log file from the Log folder of this utility to ensure that no errors were reported during the import process. In case of an error, send the Log file to TechnoSolutions Support <\/i>so that it can be verified.<\/p>\n<\/div><\/div>\n NOTE: <\/strong>Run Text Indexer Service of TopTeam Application Server <\/i>and perform Rebuild Indexes<\/strong>.<\/i> Exporting repository data from Firebird Database step by step<\/a> Revised: September 7th, 2016<\/p>\n<\/div><\/div>\n<\/p><\/div>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Overview 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. Who should read this? TopTeam Administrators Visual Use Case Administrators IT Support System Administrators Database Administrators <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,45,46,7,295],"class_list":["post-2358","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-import","tag-oracle","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-C2","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2358"}],"version-history":[{"count":11,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358\/revisions"}],"predecessor-version":[{"id":46745,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2358\/revisions\/46745"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2358"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Who should read this? <\/h3>\n
\n
Process Concept Diagram <\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Preparations<\/h3>\n
\n (This is automatically done as a part of the TopTeam Application Server for Oracle <\/i>installation process) <\/p>\n
\n <\/strong>Or,
\n You should have the Username\/Password for TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers<\/font>) in order to download the Export\/Import utility.<\/i><\/p>\n
\n The Import\/Export utility <\/i>name contains its Database Schema compatibility range.
\n For example; TopTeam_Export-Import_Oracle_Db_Vrsn_2.8-3.4_06Nov07.zip<\/strong> file indicates that it is compatible with ALL Database Schema versions between 2.8 and 3.4.<\/p>\nStep 1. Download the Oracle Server Database Import utility<\/h3>\n
Step 2. Unzip the Import utility<\/h3>\n
\nIn other words, the computer should already have the required Oracle<\/i> Database<\/i> connectivity files (DLLs, etc.). If the computer has any Oracle Database Management <\/i>utility installed on it, then the connectivity files are automatically installed along with it.<\/p>\nStep 3. Stop TopTeam Application Server and Web Server<\/h3>\n
\n
\n
Step 4. Run the TopTeam Import utility<\/h3>\n
\n5.0<\/strong> – is the compatible TopTeam Database<\/i> version.
\nora –<\/strong> is the Import\/Export utility <\/i>for Oracle Database.<\/i>
\n22Feb2010 <\/strong>– is the release date of the Import\/Export utility.<\/i><\/p>\n<\/div><\/div>\nStep 5. Welcome screen for Data Export\/Import Wizard for Oracle displays<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 6. Accept the License Agreement <\/h3>\n
\n<\/div>\n
Step 7. Choose an operation<\/h3>\n
\n<\/div>\n
Step 8. Login to the database<\/h3>\n
\n<\/div>\n
Step 9. Select the exported file path<\/h3>\n
\n<\/div>\n
Step 10. Review Data Import Summary<\/h3>\n
\n<\/div>\n
Step 11. Start the import operation<\/h3>\n
\n<\/div>\n
Step 12. Delete Confirmation<\/h3>\n
\n<\/div>\n
Step 13. Monitor data import<\/h3>\n
\n<\/div>\n
Step 14. Review the Import Log file <\/h3>\n
\n<\/div>\n
\nThere is a summary report generated at the end of the Log file.
\nIf you see the word “ERROR<\/strong>” that means the import was not successful.<\/p>\nStep 15. Post TopTeam Database Import step<\/h3>\n
\nIf this step is not done, you will not be able to search records using the full text search function of TopTeam<\/i> Desktop App<\/i>.<\/p>\n<\/div><\/div>\nSee Also<\/h3>\n
\nMigrating your repository from one database type to another database type<\/a>
\nImporting previously exported repository data into SQL Server Database step by step<\/a>
\nExporting repository data from SQL Database step by step<\/a><\/p>\n<\/div><\/div>\n