Overview<\/h3>\n\nTopTeam<\/i> and Visual Use Case<\/i> repository data can be exported from Firebird Database<\/i> to migrate the repository to SQL Server or Oracle databases. All data including, projects, requirements, use cases, other repository objects, trace relationships, tracking items, user accounts, security and workflow configuration, etc. are exported from the repository database.<\/p>\n
NOTE: <\/strong>This export utility should NOT be used for the purpose of taking regular day-to-day database backups. For taking regular database backups, use the native database utilities supplied with the database.<\/p>\nThis article describes the step-by-step procedure for exporting repository data from Firebird Database<\/i> using TechnoSolutions’ Import\/Export utility.<\/p>\n<\/div>\n<\/div>\n\nWho should read this?<\/h3>\n\n\n- TopTeam Administrators<\/li>\n
- Visual Use Case Administrators<\/li>\n
- System Administrators<\/li>\n
- IT Support<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Process Concept Diagram<\/h3>\n![\"wpid-media_12825436655011.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
<\/div>\n<\/div>\n\nPreparations<\/h3>\n\nYou need to have the following in order to successfully export data from Firebird Database.<\/i><\/p>\n
1. Username and Password for Firebird Database <\/i>(for the repository database: TopTeam.gdb).
\nThe default Username and Password for Firebird Database<\/i> is sysdba<\/strong><\/i> and masterkey<\/i>.<\/strong><\/p>\n2. The TechnoSolutions Firebird Import\/Export<\/i> utility available to you.
\nOr,
\nUsername and Password for the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) in order to download the Import\/Export utility.<\/p>\n3. Ensure that the Import\/Export utility has the DB Schema version compatibility with your existing repository DB Schema.<\/p>\n
The Import\/Export utility name has its DB Schema compatibility range.
\nFor example; ImpExp2.09_DBVer_5.0-BatchSize50_IBEmbedded1.5.2-14Jul2010.zip file indicates that it is compatible with ALL DB Schema versions between 2.09 and 5.0.<\/p>\n<\/div>\n<\/div>\n
\nStep 1. Download the Import\/Export utility<\/h3>\n\nDownload the Import\/Export <\/i>utility from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) for repository Firebird Database <\/i>.<\/p>\n<\/div>\n<\/div>\n\nStep 2. Unzip this file into an empty folder<\/h3>\n<\/div>\n\nUnzip this file into an empty folder.<\/p>\n<\/div>\n<\/div>\n
\nStep 3. Stop all running instances of TopTeam Application Server and TopTeam Web Application Server<\/h3>\n\nBefore exporting TopTeam Database<\/i>, stop TopTeam Application Server<\/i> and TopTeam Web Server.<\/i><\/span>
\nUsers of TopTeam<\/i> will not be able to connect to TopTeam repository <\/i>during the export of TopTeam Database.<\/i><\/span><\/p>\n\n- Refer to the article <\/span>How to start and stop TopTeam Application Server<\/span><\/a> for the<\/span> procedure to stop TopTeam Application Server.<\/i><\/span><\/li>\n
- Refer to the article <\/span>How to start and stop TopTeam Web Server<\/span><\/a> for the<\/span> procedure to stop TopTeam Web server.<\/i><\/span><\/li>\n<\/ul>\n
NOTE: <\/span><\/strong>E<\/span>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 Application<\/i> Server has been stopped.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Step 4. Run the Export utility<\/h3>\n\nDouble-click on the exe<\/strong><\/i> file (ImpExp_<<…>>_IBE.exe) to run the utility.<\/p>\n<\/div>\n<\/div>\n\nStep 5. Read and choose the I accept… option for the License Agreement<\/h3>\n<\/div>\n<\/div>\n\nStep 6. Welcome to the Export\/Import Wizard<\/h3>\n<\/div>\n<\/div>\n\nStep 7. Choose Export Data<\/h3>\n<\/div>\n<\/div>\n\nStep 8. Login to the database<\/h3>\n<\/div>\n\nNOTE:<\/strong> In older versions of TopTeam<\/i>, you may find the database extension as .GDB.<\/p>\n<\/div>\n<\/div>\n\nStep 9. Select the destination folder and Filename<\/h3>\n<\/div>\n\nEnter the destination folder and Filename for the export file that will be created. We recommend that you use a new “empty folder”.<\/p>\n
Ensure that you have sufficient free space on the selected drive for the entire export.<\/p>\n<\/div>\n<\/div>\n
\nStep 10. View the summary information<\/h3>\n<\/div>\n\nReview the summary information and click Export<\/strong><\/i> to begin exporting data from the database.<\/p>\n<\/div>\n<\/div>\n\nStep 11. Finish the export<\/h3>\n<\/div>\n\nClick Finish<\/strong><\/i> to exit the utility.<\/p>\n<\/div>\n<\/div>\n\nStep 12. Review the Log file<\/h3>\n\nReview the Log file from the Log folder of this utility to ensure that no errors were reported during the export process.<\/p>\n<\/div>\n<\/div>\n
\nSee Also<\/h3>\n\nMigrating TopTeam SQL Server Database from older version to the latest version<\/a>
\nImporting previously exported repository data into Oracle Server Database step-by-step<\/a>
\nImporting previously exported repository data into SQL Server Database step-by-step<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 3rd, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview TopTeam and Visual Use Case repository data can be exported from Firebird Database to migrate the repository to SQL Server or Oracle databases. All data including, projects, requirements, use cases, other repository objects, trace relationships, tracking items, user accounts, security and workflow configuration, etc. are exported from the repository database. NOTE: This export utility should NOT be used for the purpose of taking regular day-to-day database backups. For taking regular database backups, use the native database utilities supplied with the database. This article describes the step-by-step procedure for exporting repository data from Firebird Database using TechnoSolutions’ Import\/Export utility. Who <\/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,8],"class_list":["post-2633","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-firebird"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Gt","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633","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=2633"}],"version-history":[{"count":9,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633\/revisions"}],"predecessor-version":[{"id":49537,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633\/revisions\/49537"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2633"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
TopTeam<\/i> and Visual Use Case<\/i> repository data can be exported from Firebird Database<\/i> to migrate the repository to SQL Server or Oracle databases. All data including, projects, requirements, use cases, other repository objects, trace relationships, tracking items, user accounts, security and workflow configuration, etc. are exported from the repository database.<\/p>\n
NOTE: <\/strong>This export utility should NOT be used for the purpose of taking regular day-to-day database backups. For taking regular database backups, use the native database utilities supplied with the database.<\/p>\n This article describes the step-by-step procedure for exporting repository data from Firebird Database<\/i> using TechnoSolutions’ Import\/Export utility.<\/p>\n<\/div>\n<\/div>\n You need to have the following in order to successfully export data from Firebird Database.<\/i><\/p>\n 1. Username and Password for Firebird Database <\/i>(for the repository database: TopTeam.gdb). 2. The TechnoSolutions Firebird Import\/Export<\/i> utility available to you. 3. Ensure that the Import\/Export utility has the DB Schema version compatibility with your existing repository DB Schema.<\/p>\n The Import\/Export utility name has its DB Schema compatibility range. Download the Import\/Export <\/i>utility from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) for repository Firebird Database <\/i>.<\/p>\n<\/div>\n<\/div>\n Unzip this file into an empty folder.<\/p>\n<\/div>\n<\/div>\n Before exporting TopTeam Database<\/i>, stop TopTeam Application Server<\/i> and TopTeam Web Server.<\/i><\/span> NOTE: <\/span><\/strong>E<\/span>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><\/i> file (ImpExp_<<…>>_IBE.exe) to run the utility.<\/p>\n<\/div>\n<\/div>\n NOTE:<\/strong> In older versions of TopTeam<\/i>, you may find the database extension as .GDB.<\/p>\n<\/div>\n<\/div>\n Enter the destination folder and Filename for the export file that will be created. We recommend that you use a new “empty folder”.<\/p>\n Ensure that you have sufficient free space on the selected drive for the entire export.<\/p>\n<\/div>\n<\/div>\n Review the summary information and click Export<\/strong><\/i> to begin exporting data from the database.<\/p>\n<\/div>\n<\/div>\n Click Finish<\/strong><\/i> to exit the utility.<\/p>\n<\/div>\n<\/div>\n Review the Log file from the Log folder of this utility to ensure that no errors were reported during the export process.<\/p>\n<\/div>\n<\/div>\n Migrating TopTeam SQL Server Database from older version to the latest version<\/a> Revised: September 3rd, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Overview TopTeam and Visual Use Case repository data can be exported from Firebird Database to migrate the repository to SQL Server or Oracle databases. All data including, projects, requirements, use cases, other repository objects, trace relationships, tracking items, user accounts, security and workflow configuration, etc. are exported from the repository database. NOTE: This export utility should NOT be used for the purpose of taking regular day-to-day database backups. For taking regular database backups, use the native database utilities supplied with the database. This article describes the step-by-step procedure for exporting repository data from Firebird Database using TechnoSolutions’ Import\/Export utility. Who <\/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,8],"class_list":["post-2633","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-firebird"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Gt","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633","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=2633"}],"version-history":[{"count":9,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633\/revisions"}],"predecessor-version":[{"id":49537,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2633\/revisions\/49537"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2633"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Who should read this?<\/h3>\n
\n
Process Concept Diagram<\/h3>\n
<\/div>\n<\/div>\n
Preparations<\/h3>\n
\nThe default Username and Password for Firebird Database<\/i> is sysdba<\/strong><\/i> and masterkey<\/i>.<\/strong><\/p>\n
\nOr,
\nUsername and Password for the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) in order to download the Import\/Export utility.<\/p>\n
\nFor example; ImpExp2.09_DBVer_5.0-BatchSize50_IBEmbedded1.5.2-14Jul2010.zip file indicates that it is compatible with ALL DB Schema versions between 2.09 and 5.0.<\/p>\n<\/div>\n<\/div>\nStep 1. Download the Import\/Export utility<\/h3>\n
Step 2. Unzip this file into an empty folder<\/h3>\n
<\/div>\n
Step 3. Stop all running instances of TopTeam Application Server and TopTeam Web Application Server<\/h3>\n
\nUsers of TopTeam<\/i> will not be able to connect to TopTeam repository <\/i>during the export of TopTeam Database.<\/i><\/span><\/p>\n\n
\n
Step 4. Run the Export utility<\/h3>\n
Step 5. Read and choose the I accept… option for the License Agreement<\/h3>\n
<\/div>\n<\/div>\n
Step 6. Welcome to the Export\/Import Wizard<\/h3>\n
<\/div>\n<\/div>\n
Step 7. Choose Export Data<\/h3>\n
<\/div>\n<\/div>\n
Step 8. Login to the database<\/h3>\n
<\/div>\n
Step 9. Select the destination folder and Filename<\/h3>\n
<\/div>\n
Step 10. View the summary information<\/h3>\n
<\/div>\n
Step 11. Finish the export<\/h3>\n
<\/div>\n
Step 12. Review the Log file<\/h3>\n
See Also<\/h3>\n
\nImporting previously exported repository data into Oracle Server Database step-by-step<\/a>
\nImporting previously exported repository data into SQL Server Database step-by-step<\/a><\/p>\n<\/div>\n<\/div>\n