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<\/i> or Oracle<\/i> databases. All data including, all 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<\/strong> 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 articles explains the step-by-step procedure for exporting repository data from SQL Server Database<\/i> using TechnoSolutions’ Import\/Export utility.<\/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![\"wpid29210-media_1282543665501.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
\n<\/div>\n<\/p><\/div>\n\nPreparations<\/h3>\n\nYou need to have the following in order to successfully export data from SQL Server Database<\/i>.<\/p>\n
1. Username<\/i> and Password<\/i> for the SQL Server Database<\/i>.<\/p>\n
2. TechnoSolutions SQL Server Import\/Export<\/i> utility available with you.
\n Or,
\n Username<\/i> and Password<\/i> for the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers<\/font>) in order to download the Import\/Export utility.<\/p>\n 3. Ensure that the Import\/Export<\/i> utility has DB Schema<\/i> version compatibility with your existing repository DB Schema.
\n The Import\/Export <\/i>utility name has its DB Schema compatibility range.
\n For example; ImpExp2.09_DBVer_5.0-BatchSize50_ss-14Jul2010.zip file indicates that it is compatible with ALL DB Schema versions between 2.09 and 5.0.<\/p>\n<\/div><\/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<\/font>) for SQL Server Database.<\/i><\/p>\n<\/div><\/div>\n\nStep 2. Unzip this file into an empty folder<\/h3>\n\n\n<\/div>\n\nUnzip this file into an empty folder.<\/p>\n<\/div><\/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><\/font>
\nUsers of TopTeam<\/i> will not be able to connect to TopTeam repository<\/i> during export of TopTeam Database<\/i>.<\/font><\/p>\nRefer the following articles to stop:<\/p>\n
\n- TopTeam Application Server – How to start and stop TopTeam Application Server.<\/a><\/li>\n
- TopTeam Web Server installed as Service Edition – How to start and stop TopTeam Web Server.<\/a><\/li>\n
- TopTeam Web Server installed as ISAPI Dll – 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 SQL Server 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 Export utility<\/h3>\n\nDouble-click on the exe<\/strong> file (ImpExp_<<…>>_ss.exe) to run the utility.<\/p>\n<\/div><\/div>\n\nStep 5. Accept the License Agreement <\/h3>\n\n\n<\/div>\n\nRead the License Agreement and accept it to proceed ahead with exporting repository data from SQL Server Database<\/i>.<\/p>\n<\/div><\/div>\n\nStep 6. Welcome to the Export\/Import Wizard<\/h3>\n\n\n<\/div>\n<\/p><\/div>\n\nStep 7. Choose Export Data<\/h3>\n\n\n<\/div>\n\nClick Next<\/strong><\/i> to proceed for repository data export from SQL Server Database<\/i>.<\/p>\n<\/div><\/div>\n\nStep 8. Login to the database<\/h3>\n\n\n<\/div>\n\nEnter Username<\/i> and Password<\/i> for SQL Server<\/i>. Click Next<\/i> to proceed.<\/p>\n<\/div><\/div>\n\nStep 9. Select the database<\/h3>\n\n\n<\/div>\n\nSelect TopTeam Database<\/i> in SQL Server <\/i>where the data export operation will be performed.<\/p>\n<\/div><\/div>\n\nStep 10. Summary information <\/h3>\n\n\n<\/div>\n\nReview the summary information and click Export<\/i> to begin exporting data from the database.<\/p>\n<\/div><\/div>\n\nStep 11. Finish the export process<\/h3>\n\n\n<\/div>\n\nClick Finish<\/strong><\/i> to exit the utility.<\/p>\n<\/div><\/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><\/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><\/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 repository data can be exported from Firebird Database to migrate the repository to SQL Server or Oracle databases. All data including, all 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 articles explains the step-by-step procedure for exporting repository data from SQL Server Database using TechnoSolutions’ Import\/Export <\/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,9],"class_list":["post-2368","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Cc","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368","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=2368"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368\/revisions"}],"predecessor-version":[{"id":46768,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368\/revisions\/46768"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2368"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2368"}],"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<\/i> or Oracle<\/i> databases. All data including, all 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<\/strong> 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 articles explains the step-by-step procedure for exporting repository data from SQL Server Database<\/i> using TechnoSolutions’ Import\/Export utility.<\/p>\n<\/div><\/div>\n You need to have the following in order to successfully export data from SQL Server Database<\/i>.<\/p>\n 1. Username<\/i> and Password<\/i> for the SQL Server Database<\/i>.<\/p>\n 2. TechnoSolutions SQL Server Import\/Export<\/i> utility available with you. 3. Ensure that the Import\/Export<\/i> utility has DB Schema<\/i> version compatibility with your existing repository DB Schema. Download the Import\/Export <\/i>utility from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers<\/font>) for SQL Server Database.<\/i><\/p>\n<\/div><\/div>\n Unzip this file into an empty folder.<\/p>\n<\/div><\/div>\n Before exporting TopTeam Database<\/i>, stop TopTeam Application Server <\/i>and TopTeam Web Server.<\/i><\/font> Refer the following articles to stop:<\/p>\n NOTE: <\/font><\/strong>E<\/font>nsure that you have stopped all access to the repository SQL Server Database<\/i> before starting the export.<\/p>\n Double-click on the exe<\/strong> file (ImpExp_<<…>>_ss.exe) to run the utility.<\/p>\n<\/div><\/div>\n Read the License Agreement and accept it to proceed ahead with exporting repository data from SQL Server Database<\/i>.<\/p>\n<\/div><\/div>\n Click Next<\/strong><\/i> to proceed for repository data export from SQL Server Database<\/i>.<\/p>\n<\/div><\/div>\n Enter Username<\/i> and Password<\/i> for SQL Server<\/i>. Click Next<\/i> to proceed.<\/p>\n<\/div><\/div>\n Select TopTeam Database<\/i> in SQL Server <\/i>where the data export operation will be performed.<\/p>\n<\/div><\/div>\n Review the summary information and click Export<\/i> to begin exporting data from the database.<\/p>\n<\/div><\/div>\n Click Finish<\/strong><\/i> to exit the utility.<\/p>\n<\/div><\/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><\/div>\n 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 repository data can be exported from Firebird Database to migrate the repository to SQL Server or Oracle databases. All data including, all 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 articles explains the step-by-step procedure for exporting repository data from SQL Server Database using TechnoSolutions’ Import\/Export <\/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,9],"class_list":["post-2368","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Cc","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368","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=2368"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368\/revisions"}],"predecessor-version":[{"id":46768,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2368\/revisions\/46768"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2368"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2368"}],"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 Or,
\n Username<\/i> and Password<\/i> for the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers<\/font>) in order to download the Import\/Export utility.<\/p>\n
\n The Import\/Export <\/i>utility name has its DB Schema compatibility range.
\n For example; ImpExp2.09_DBVer_5.0-BatchSize50_ss-14Jul2010.zip file indicates that it is compatible with ALL DB Schema versions between 2.09 and 5.0.<\/p>\n<\/div><\/div>\nStep 1. Download the Import\/Export utility <\/h3>\n
Step 2. Unzip this file into an empty folder<\/h3>\n
\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 export of TopTeam Database<\/i>.<\/font><\/p>\n\n
\n
Step 4. Run the Export utility<\/h3>\n
Step 5. Accept the License Agreement <\/h3>\n
\n<\/div>\n
Step 6. Welcome to the Export\/Import Wizard<\/h3>\n
\n<\/div>\n<\/p><\/div>\n
Step 7. Choose Export Data<\/h3>\n
\n<\/div>\n
Step 8. Login to the database<\/h3>\n
\n<\/div>\n
Step 9. Select the database<\/h3>\n
\n<\/div>\n
Step 10. Summary information <\/h3>\n
\n<\/div>\n
Step 11. Finish the export process<\/h3>\n
\n<\/div>\n
Step 12. Review the Log file <\/h3>\n
See 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><\/p>\n<\/div><\/div>\n