Overview<\/h3>\n\nTopTeam<\/i> and Visual Use Case<\/i> repository data that has been previously exported using a TechnoSolutions Repository Export<\/i> utility<\/i> can be imported into TopTeam SQL Server 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 Microsoft SQL Server Repository Database Schema.<\/i><\/p>\n
This article illustrates the step-by-step procedure for importing previously exported repository data using the TechnoSolutions Export utility<\/i> (as *.eif<\/i> and *.exp<\/i> files) into Microsoft SQL Server Database<\/i>.<\/p>\n<\/div>\n<\/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>\n<\/div>\n\n
Process Concept Diagram<\/h3>\n![\"wpid28356-wpid-media_12825878472421.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
<\/div>\n<\/div>\n\nPreparations<\/h3>\n\nYou should have the following in order to successfully import data into SQL Server Database<\/i>:<\/p>\n
1. Ensure that TopTeam<\/i>\/Visual Use Case Schema<\/i> is already installed on SQL Server Database<\/i>.
\n(This is automatically done as a part of TopTeam Application Server for SQL Server<\/i> installation process)
\nIt is recommended <\/strong>to import repository data into a newly<\/i> installed TopTeam Database <\/i>and not<\/strong> in TopTeam Database <\/i>which was already in use and has some data.<\/p>\n2. Ensure that TechnoSolutions<\/i> Import\/Export utility<\/strong><\/i> for SQL Server Database<\/i> is available with you.
\nOr,
\nDownload Export\/Import utility<\/strong><\/i> from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n3. Ensure that the Username and Password for TopTeam Database Schema on SQL Server <\/i>is available with you.<\/p>\n
4. TopTeam\/VUC Repository Database Schema<\/i> on SQL Server <\/i>must be of the same version as the Database<\/i> Schema<\/i> version<\/i> in the export (*.eif<\/i>) files.
\nIn other words, you can only import data from another repository which has the same Database Schema version as the destination database.<\/i><\/p>\n
5. Ensure that there is no data in TopTeam\/Visual Use Case<\/i> repository on the destination SQL Server Database Schema. <\/i>
\n Any<\/strong> existing data in TopTeam repository<\/i> tables will be overwritten during the import process<\/strong>.<\/p>\n<\/div>\n<\/div>\n\nStep 1. Download the SQL Server Database Import utility<\/h3>\n\nDownload SQL Server Database Import utility<\/i> from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n\nStep 2. Unzip the Import utility<\/h3>\n\nUnzip the Import utility <\/i>file into an empty folder on a computer which is capable of connecting to SQL Server Database<\/i>.
\nIn other words, the computer should already have the required SQL Server<\/i> connectivity files (DLLs, etc.). Also, if the computer has any SQL Server 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 SQL Server Database<\/i> using SQL Server Management Studio<\/i> from this computer, you have all the appropriate files and configuration that is required for connecting to SQL Server Database.<\/i><\/p>\n<\/div>\n<\/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 <\/i>all access to TopTeam Database <\/i>on SQL Server is stopped before starting the import<\/strong>.<\/i><\/p>\nRefer to the below articles to stop:<\/span><\/p>\n\n- TopTeam Application Server <\/span><\/strong>– <\/span>How to start and stop TopTeam Application Server Service using Management Console<\/a><\/li>\n
- TopTeam Web Server –<\/span><\/strong> How to start and stop TopTeam Web Server – Service using Management Console<\/a><\/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>\n1. Ensure that TopTeam Application Server<\/i> has been stopped.
\n2. Ensure that TopTeam Web Application Server<\/i> has been stopped.<\/p>\n<\/div>\n<\/div>\n\nStep 4. Run the TopTeam Import utility<\/h3>\n\nDouble-click the exe<\/strong> file (ttmImpExp_<<…>>_SS.exe) to run the utility.<\/p>\nThe installer file name format is: TopTeamIBServerLic_Installer_<TopTeam IB Server Version><\/strong>_Min_DB<TopTeam Database Schema Version Required><\/strong>_<Release Date><\/strong>.exe<\/p>\nE.g. ImpExp2.09_DBVer_5.0-BatchSize50_SQLServer-14Jul2010(2).zip <\/strong><\/p>\nIn the example above:
\n2.09 <\/strong>– is the version number of the Import\/Export utility.<\/i>
\n5.0<\/strong> – is the compatible TopTeam Database<\/i> version.
\n14Jul2010(2)<\/strong> – is the release date of the Import\/Export utility.<\/i><\/p>\n<\/div>\n<\/div>\n\nStep 5. Accept the License Agreement<\/h3>\n<\/div>\n\nAfter reading the License Agreement, choose “I accept…<\/strong><\/i>” to proceed ahead with data Export\/Import.<\/p>\n<\/div>\n<\/div>\n\nStep 6. Welcome screen for Data Export\/Import Wizard for SQL Server displays<\/h3>\n<\/div>\n<\/div>\n\nStep 7. Select an operation<\/h3>\n<\/div>\n\nChoose the “Import Data<\/i>” option to import exported data into SQL Server.<\/i><\/p>\n<\/div>\n<\/div>\n\nStep 8. Login to the database<\/h3>\n<\/div>\n\nEnter Username<\/i> and Password<\/i> for SQL Server. <\/i>Click Next<\/strong><\/i> to proceed.<\/p>\n<\/div>\n<\/div>\n\nStep 9. Select the database<\/h3>\n<\/div>\n\nSelect TopTeam Database <\/i>in SQL Server<\/i> where the data import operation will be performed.<\/p>\n<\/div>\n<\/div>\n\nStep 10. Select the exported file path<\/h3>\n<\/div>\n\nBrowse to the location where the exported repository data files are placed. Extension of the export data files is .eif<\/i><\/strong>.<\/p>\nNOTE:<\/strong> The file must be an export from another TopTeam<\/i> repository.<\/p>\n<\/div>\n<\/div>\n\nStep 11. Review Data Import Summary<\/h3>\n<\/div>\n\nClick Next<\/strong><\/i> to start the data import into SQL Server Database<\/i>.<\/p>\n<\/div>\n<\/div>\n\nStep 12. Start the import operation<\/h3>\n<\/div>\n\nBefore the import operation, any existing data in TopTeam Database Schema<\/i> will be deleted. Therefore, it is recommended to import the exported data into the new TopTeam Database Schema<\/i>.<\/p>\n
Click Import<\/strong><\/i> to start the import operation.<\/p>\n<\/div>\n<\/div>\n\nStep 13. Delete Confirmation<\/h3>\n<\/div>\n\nType “yes<\/i>” to confirm replacing the contents of TopTeam\/Visual Use Case<\/i> repository in the target SQL Server Database <\/i>with the information 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>\n<\/div>\n\nStep 14. Click Finish<\/h3>\n<\/div>\n\nClick “Finish<\/i>“<\/strong> to exit the Wizard once the import operation is completed.<\/p>\n<\/div>\n<\/div>\n\nStep 15. Review the Import Log file<\/h3>\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.
\nA summary report is generated at the end of the Log file.
\nIf you see the word “ERROR<\/strong>” in the Log file, that means import was not successful.<\/p>\n*In case of an error, send the Log file to TechnoSolutions Support <\/i>so that it can be verified.<\/p>\n<\/div>\n<\/div>\n\nStep 16. Post TopTeam Database import step<\/h3>\n\nNOTE: <\/strong>Run Text Indexer Service <\/i>of TopTeam Application Server <\/i>and perform Rebuild Indexes<\/strong>.<\/i>
\nRefer to the article How to start and stop Text Indexer Service<\/a> for more details. If this step is not performed, you will not be able to search records using the full text search function of TopTeam Desktop App.<\/i><\/p>\n<\/div>\n<\/div>\n\nSee Also<\/h3>\n\nExporting repository data from SQL Database step-by-step<\/a>
\nExporting repository data from Firebird Database step_by_step<\/a>
\nMigrating TopTeam SQL Server Database from SQL Server from older version to the latest version<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 4th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview TopTeam and Visual Use Case repository data that has been previously exported using a TechnoSolutions Repository Export utility can be imported into TopTeam SQL Server 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 Microsoft SQL Server Repository Database Schema. This article illustrates the step-by-step procedure for importing previously exported repository data using the TechnoSolutions Export utility (as *.eif and *.exp files) into Microsoft SQL Server Database. Who should read this? TopTeam Administrators Visual Use Case Administrators IT Support System Administrators Database <\/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,9],"class_list":["post-2595","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-import","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-FR","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595","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=2595"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595\/revisions"}],"predecessor-version":[{"id":49541,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595\/revisions\/49541"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2595"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
TopTeam<\/i> and Visual Use Case<\/i> repository data that has been previously exported using a TechnoSolutions Repository Export<\/i> utility<\/i> can be imported into TopTeam SQL Server 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 Microsoft SQL Server Repository Database Schema.<\/i><\/p>\n
This article illustrates the step-by-step procedure for importing previously exported repository data using the TechnoSolutions Export utility<\/i> (as *.eif<\/i> and *.exp<\/i> files) into Microsoft SQL Server Database<\/i>.<\/p>\n<\/div>\n<\/div>\n You should have the following in order to successfully import data into SQL Server Database<\/i>:<\/p>\n 1. Ensure that TopTeam<\/i>\/Visual Use Case Schema<\/i> is already installed on SQL Server Database<\/i>. 2. Ensure that TechnoSolutions<\/i> Import\/Export utility<\/strong><\/i> for SQL Server Database<\/i> is available with you. 3. Ensure that the Username and Password for TopTeam Database Schema on SQL Server <\/i>is available with you.<\/p>\n 4. TopTeam\/VUC Repository Database Schema<\/i> on SQL Server <\/i>must be of the same version as the Database<\/i> Schema<\/i> version<\/i> in the export (*.eif<\/i>) files. 5. Ensure that there is no data in TopTeam\/Visual Use Case<\/i> repository on the destination SQL Server Database Schema. <\/i> Download SQL Server Database Import utility<\/i> from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n Unzip the Import utility <\/i>file into an empty folder on a computer which is capable of connecting to SQL Server Database<\/i>. NOTE: <\/strong>If you can successfully connect to SQL Server Database<\/i> using SQL Server Management Studio<\/i> from this computer, you have all the appropriate files and configuration that is required for connecting to SQL Server Database.<\/i><\/p>\n<\/div>\n<\/div>\n Ensure that TopTeam Application Server<\/i> and TopTeam Web Server <\/i>are stopped<\/strong><\/i> so that <\/i>all access to TopTeam Database <\/i>on SQL Server is stopped before starting the import<\/strong>.<\/i><\/p>\n Refer to the below articles to stop:<\/span><\/p>\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 1. Ensure that TopTeam Application Server<\/i> has been stopped. Double-click the exe<\/strong> file (ttmImpExp_<<…>>_SS.exe) to run the utility.<\/p>\n The installer file name format is: TopTeamIBServerLic_Installer_<TopTeam IB Server Version><\/strong>_Min_DB<TopTeam Database Schema Version Required><\/strong>_<Release Date><\/strong>.exe<\/p>\n E.g. ImpExp2.09_DBVer_5.0-BatchSize50_SQLServer-14Jul2010(2).zip <\/strong><\/p>\n In the example above: After reading the License Agreement, choose “I accept…<\/strong><\/i>” to proceed ahead with data Export\/Import.<\/p>\n<\/div>\n<\/div>\n Choose the “Import Data<\/i>” option to import exported data into SQL Server.<\/i><\/p>\n<\/div>\n<\/div>\n Enter Username<\/i> and Password<\/i> for SQL Server. <\/i>Click Next<\/strong><\/i> to proceed.<\/p>\n<\/div>\n<\/div>\n Select TopTeam Database <\/i>in SQL Server<\/i> where the data import operation will be performed.<\/p>\n<\/div>\n<\/div>\n Browse to the location where the exported repository data files are placed. Extension of the export data files is .eif<\/i><\/strong>.<\/p>\n NOTE:<\/strong> The file must be an export from another TopTeam<\/i> repository.<\/p>\n<\/div>\n<\/div>\n Click Next<\/strong><\/i> to start the data import into SQL Server Database<\/i>.<\/p>\n<\/div>\n<\/div>\n Before the import operation, any existing data in TopTeam Database Schema<\/i> will be deleted. Therefore, it is recommended to import the exported data into the new TopTeam Database Schema<\/i>.<\/p>\n Click Import<\/strong><\/i> to start the import operation.<\/p>\n<\/div>\n<\/div>\n Type “yes<\/i>” to confirm replacing the contents of TopTeam\/Visual Use Case<\/i> repository in the target SQL Server Database <\/i>with the information 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>\n<\/div>\n Click “Finish<\/i>“<\/strong> to exit the Wizard once the import operation is completed.<\/p>\n<\/div>\n<\/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>\n<\/div>\n NOTE: <\/strong>Run Text Indexer Service <\/i>of TopTeam Application Server <\/i>and perform Rebuild Indexes<\/strong>.<\/i> Exporting repository data from SQL Database step-by-step<\/a> Revised: September 4th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Overview TopTeam and Visual Use Case repository data that has been previously exported using a TechnoSolutions Repository Export utility can be imported into TopTeam SQL Server 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 Microsoft SQL Server Repository Database Schema. This article illustrates the step-by-step procedure for importing previously exported repository data using the TechnoSolutions Export utility (as *.eif and *.exp files) into Microsoft SQL Server Database. Who should read this? TopTeam Administrators Visual Use Case Administrators IT Support System Administrators Database <\/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,9],"class_list":["post-2595","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-export","tag-import","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-FR","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595","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=2595"}],"version-history":[{"count":12,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595\/revisions"}],"predecessor-version":[{"id":49541,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2595\/revisions\/49541"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2595"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2595"}],"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
\n(This is automatically done as a part of TopTeam Application Server for SQL Server<\/i> installation process)
\nIt is recommended <\/strong>to import repository data into a newly<\/i> installed TopTeam Database <\/i>and not<\/strong> in TopTeam Database <\/i>which was already in use and has some data.<\/p>\n
\nOr,
\nDownload Export\/Import utility<\/strong><\/i> from TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n
\nIn other words, you can only import data from another repository which has the same Database Schema version as the destination database.<\/i><\/p>\n
\n Any<\/strong> existing data in TopTeam repository<\/i> tables will be overwritten during the import process<\/strong>.<\/p>\n<\/div>\n<\/div>\nStep 1. Download the SQL Server Database Import utility<\/h3>\n
Step 2. Unzip the Import utility<\/h3>\n
\nIn other words, the computer should already have the required SQL Server<\/i> connectivity files (DLLs, etc.). Also, if the computer has any SQL Server 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
\n2. Ensure that TopTeam Web Application Server<\/i> has been stopped.<\/p>\n<\/div>\n<\/div>\nStep 4. Run the TopTeam Import utility<\/h3>\n
\n2.09 <\/strong>– is the version number of the Import\/Export utility.<\/i>
\n5.0<\/strong> – is the compatible TopTeam Database<\/i> version.
\n14Jul2010(2)<\/strong> – is the release date of the Import\/Export utility.<\/i><\/p>\n<\/div>\n<\/div>\nStep 5. Accept the License Agreement<\/h3>\n
<\/div>\n
Step 6. Welcome screen for Data Export\/Import Wizard for SQL Server displays<\/h3>\n
<\/div>\n<\/div>\n
Step 7. Select an operation<\/h3>\n
<\/div>\n
Step 8. Login to the database<\/h3>\n
<\/div>\n
Step 9. Select the database<\/h3>\n
<\/div>\n
Step 10. Select the exported file path<\/h3>\n
<\/div>\n
Step 11. Review Data Import Summary<\/h3>\n
<\/div>\n
Step 12. Start the import operation<\/h3>\n
<\/div>\n
Step 13. Delete Confirmation<\/h3>\n
<\/div>\n
Step 14. Click Finish<\/h3>\n
<\/div>\n
Step 15. Review the Import Log file<\/h3>\n
<\/div>\n
\nA summary report is generated at the end of the Log file.
\nIf you see the word “ERROR<\/strong>” in the Log file, that means import was not successful.<\/p>\nStep 16. Post TopTeam Database import step<\/h3>\n
\nRefer to the article How to start and stop Text Indexer Service<\/a> for more details. If this step is not performed, you will not be able to search records using the full text search function of TopTeam Desktop App.<\/i><\/p>\n<\/div>\n<\/div>\nSee Also<\/h3>\n
\nExporting repository data from Firebird Database step_by_step<\/a>
\nMigrating TopTeam SQL Server Database from SQL Server from older version to the latest version<\/a><\/p>\n<\/div>\n<\/div>\n