Background<\/h3>\n\nTechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository.<\/p>\n<\/div>\n<\/div>\n
\nOverview<\/h3>\n\nThis article explains how to migrate data repository from one database type to another database type.
\nFor example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc.<\/p>\n<\/div>\n<\/div>\n
\nWho should read this?<\/h3>\n\n\n- TopTeam or Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Process Overview<\/h3>\n\n\n- Export data <\/strong>from existing database using the Export utility provided by TechnoSolutions.<\/li>\n
- Perform a new installation <\/strong>of TopTeam Application Server<\/i> (or Visual Use Case Application Server<\/i>) for the new database type.<\/li>\n
- Import data<\/strong> from Step 1 into the new database using the Import utility provided by TechnoSolutions.<\/li>\n
- Move “User Data Files”<\/strong> from existing Application Server to the corresponding folder of the new Application Server.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Preparations<\/h3>\n\n1. Ensure that TechnoSolutions’ Export utility<\/strong> <\/i>for the existing database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n2. Ensure that TechnoSolutions’ Import utility<\/strong> <\/i>for the new database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n3. The TopTeam Application Server installer<\/strong><\/i> for the new database type (unless this is already installed).
\nRefer to the following appropriate article for TopTeam Application Server<\/i>:
\na. Firebird – Installing TopTeam Application Server for Firebird<\/a>
\nb. Oracle – Installing TopTeam Application Server for Oracle<\/a>
\nc. SQL Server – Installing TopTeam Application Server for SQL Server<\/a><\/p>\n4. License Key and License Files<\/strong><\/i> for the new database type (Each database type requires a different set of Keys and Files for TopTeam<\/i> or Visual Use Case<\/i>).
\nRefer to the article How to register and load License Files in TopTeam using Management Console.<\/a><\/p>\n5. Username and Password to access the repository schema in the existing database<\/strong><\/i> (so that the Export utility can connect to the current database).<\/p>\n6. Username and Password to access the repository schema in the new database<\/strong><\/i> (so that the Import utility can connect to the new database).<\/p>\nTechnoSolutions repository Import\/Export utilities and Application Server<\/i> installers are available from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n\nStep 1. Install new TopTeam Application Server<\/h3>\n\nInstall new TopTeam Application Server<\/i> and DB Schema on the new (destination) database and apply the license keys.<\/p>\n
Refer to the following related articles:<\/p>\n
\n- Installing TopTeam Application Server for Firebird<\/a><\/li>\n
- Installing TopTeam Application Server for Oracle<\/a><\/li>\n
- Installing TopTeam Application Server for SQL Server<\/a><\/li>\n
- How to register and load License Files in TopTeam using Management Console<\/a><\/li>\n<\/ul>\n
For example: If you are moving from Firebird to MS SQL Server, you would install TopTeam\/Visual Use Case Application Server <\/i>for MS SQL Server.<\/p>\n
NOTE:<\/strong><\/p>\n\n- There is NO need to configure<\/i><\/strong> users and other application configuration on the new destination database. When you migrate from the existing database, all data, configuration settings etc. will be carried over and ANY repository related data in the new (destination) database will be overwritten.<\/li>\n
- The Repository DB Schema<\/i> version of the existing database must match the DB Schema version of the new database. Repository Schema<\/i> versions are specified as 3.2, 4.8, etc.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Step 2. Export data from existing database<\/h3>\n\nFollow these steps to export repository data from the existing database:<\/p>\n
1. Stop and exit from existing TopTeam Application Server<\/i>.<\/p>\n
2. Download the TopTeam Export\/Import utility corresponding to the existing database.<\/p>\n
For example: If you are moving from Firebird to MS SQL Server, your existing database is Firebird. You then need the TopTeam Firebird Database Export\/Import utility<\/i>.
\nFor Firebird – Use Username and Password as sysdba<\/strong><\/i> and masterkey<\/i><\/strong><\/p>\n3. Run the Export\/Import utility<\/i> on the computer where the database is running, choose the option to Export<\/i><\/strong> data<\/strong><\/i>.<\/p>\nThis will export the TopTeam\/Visual Use Case <\/i>data into a number of intermediate files.<\/p>\n<\/div>\n<\/div>\n\nStep 3. Migrate data<\/h3>\n\n1. If moving to a new computer, copy the exported data files (generated in Step 2. above) to the new computer.<\/p>\n
2. Copy “User Data Files” to the corresponding location of the new Application Server.<\/p>\n
The default location<\/strong> of the User Data Files<\/i> is:
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files – Sample<\/p>\n<\/div>\n<\/div>\n\nStep 4. Run the Import utility to import data into the new database<\/h3>\n\n1. Stop and exit from the new TopTeam Application Server<\/i>, if running.
\n(i.e. Ensure that the new TopTeam Application Server<\/i> is NOT running<\/strong>).<\/p>\n2. Download the TopTeam Export\/Import <\/i>utility corresponding to your destination database. (Download the Export\/Import utility from the TechnoSolutions Customer Portal<\/a>).<\/p>\nFor example: If you are moving from Firebird to MS SQL Server, your target database is SQL Server, so you would need the TopTeam SQL Server Database Export\/Import<\/i> utility.
\nNOTE: You will need a valid Username and Password for SQL Server.<\/strong><\/p>\nRefer to these articles:<\/p>\n
\n- Importing previously exported repository data into Oracle Server Database step_by_step<\/a><\/li>\n
- Importing previously exported repository data into SQL Server Database step by step<\/a><\/li>\n<\/ul>\n
3. Run the Export\/Import utility on the same computer on which the database is running. Choose the option to Import data.<\/p>\n
4. Restart TopTeam\/Visual Use Case Application Server<\/i>.<\/p>\n<\/div>\n<\/div>\n\nIMPORTANT:<\/h3>\n\n\n- You need to optimize the database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/li>\n
- Run “Resync Tab-indicators” from Desktop App<\/i> to resynchronize tab indicators throughout the system.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Step 5. Run “Resync Tab-indicators” from Desktop App<\/h3>\n![\"wpid19454-media_1416398654600-1.png\"](\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\")
<\/div>\n<\/div>\n\nSee Also<\/h3>\n\nImporting previously exported repository data into SQL Server Database step-by-step<\/a>
\nExporting repository data from Firebird Database step_by_step<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 8th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Background TechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository. Overview This article explains how to migrate data repository from one database type to another database type. For example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc. Who should read this? TopTeam or Visual Use Case Administrators IT Support Database Administrators Process Overview Export data from existing database using the Export utility provided by TechnoSolutions. Perform a <\/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,43,295],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-migrate","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-BQ","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346","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=2346"}],"version-history":[{"count":29,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions"}],"predecessor-version":[{"id":49542,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions\/49542"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
TechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository.<\/p>\n<\/div>\n<\/div>\n
Overview<\/h3>\n\nThis article explains how to migrate data repository from one database type to another database type.
\nFor example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc.<\/p>\n<\/div>\n<\/div>\n
\nWho should read this?<\/h3>\n\n\n- TopTeam or Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Process Overview<\/h3>\n\n\n- Export data <\/strong>from existing database using the Export utility provided by TechnoSolutions.<\/li>\n
- Perform a new installation <\/strong>of TopTeam Application Server<\/i> (or Visual Use Case Application Server<\/i>) for the new database type.<\/li>\n
- Import data<\/strong> from Step 1 into the new database using the Import utility provided by TechnoSolutions.<\/li>\n
- Move “User Data Files”<\/strong> from existing Application Server to the corresponding folder of the new Application Server.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Preparations<\/h3>\n\n1. Ensure that TechnoSolutions’ Export utility<\/strong> <\/i>for the existing database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n2. Ensure that TechnoSolutions’ Import utility<\/strong> <\/i>for the new database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n3. The TopTeam Application Server installer<\/strong><\/i> for the new database type (unless this is already installed).
\nRefer to the following appropriate article for TopTeam Application Server<\/i>:
\na. Firebird – Installing TopTeam Application Server for Firebird<\/a>
\nb. Oracle – Installing TopTeam Application Server for Oracle<\/a>
\nc. SQL Server – Installing TopTeam Application Server for SQL Server<\/a><\/p>\n4. License Key and License Files<\/strong><\/i> for the new database type (Each database type requires a different set of Keys and Files for TopTeam<\/i> or Visual Use Case<\/i>).
\nRefer to the article How to register and load License Files in TopTeam using Management Console.<\/a><\/p>\n5. Username and Password to access the repository schema in the existing database<\/strong><\/i> (so that the Export utility can connect to the current database).<\/p>\n6. Username and Password to access the repository schema in the new database<\/strong><\/i> (so that the Import utility can connect to the new database).<\/p>\nTechnoSolutions repository Import\/Export utilities and Application Server<\/i> installers are available from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n\nStep 1. Install new TopTeam Application Server<\/h3>\n\nInstall new TopTeam Application Server<\/i> and DB Schema on the new (destination) database and apply the license keys.<\/p>\n
Refer to the following related articles:<\/p>\n
\n- Installing TopTeam Application Server for Firebird<\/a><\/li>\n
- Installing TopTeam Application Server for Oracle<\/a><\/li>\n
- Installing TopTeam Application Server for SQL Server<\/a><\/li>\n
- How to register and load License Files in TopTeam using Management Console<\/a><\/li>\n<\/ul>\n
For example: If you are moving from Firebird to MS SQL Server, you would install TopTeam\/Visual Use Case Application Server <\/i>for MS SQL Server.<\/p>\n
NOTE:<\/strong><\/p>\n\n- There is NO need to configure<\/i><\/strong> users and other application configuration on the new destination database. When you migrate from the existing database, all data, configuration settings etc. will be carried over and ANY repository related data in the new (destination) database will be overwritten.<\/li>\n
- The Repository DB Schema<\/i> version of the existing database must match the DB Schema version of the new database. Repository Schema<\/i> versions are specified as 3.2, 4.8, etc.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Step 2. Export data from existing database<\/h3>\n\nFollow these steps to export repository data from the existing database:<\/p>\n
1. Stop and exit from existing TopTeam Application Server<\/i>.<\/p>\n
2. Download the TopTeam Export\/Import utility corresponding to the existing database.<\/p>\n
For example: If you are moving from Firebird to MS SQL Server, your existing database is Firebird. You then need the TopTeam Firebird Database Export\/Import utility<\/i>.
\nFor Firebird – Use Username and Password as sysdba<\/strong><\/i> and masterkey<\/i><\/strong><\/p>\n3. Run the Export\/Import utility<\/i> on the computer where the database is running, choose the option to Export<\/i><\/strong> data<\/strong><\/i>.<\/p>\nThis will export the TopTeam\/Visual Use Case <\/i>data into a number of intermediate files.<\/p>\n<\/div>\n<\/div>\n\nStep 3. Migrate data<\/h3>\n\n1. If moving to a new computer, copy the exported data files (generated in Step 2. above) to the new computer.<\/p>\n
2. Copy “User Data Files” to the corresponding location of the new Application Server.<\/p>\n
The default location<\/strong> of the User Data Files<\/i> is:
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files – Sample<\/p>\n<\/div>\n<\/div>\n\nStep 4. Run the Import utility to import data into the new database<\/h3>\n\n1. Stop and exit from the new TopTeam Application Server<\/i>, if running.
\n(i.e. Ensure that the new TopTeam Application Server<\/i> is NOT running<\/strong>).<\/p>\n2. Download the TopTeam Export\/Import <\/i>utility corresponding to your destination database. (Download the Export\/Import utility from the TechnoSolutions Customer Portal<\/a>).<\/p>\nFor example: If you are moving from Firebird to MS SQL Server, your target database is SQL Server, so you would need the TopTeam SQL Server Database Export\/Import<\/i> utility.
\nNOTE: You will need a valid Username and Password for SQL Server.<\/strong><\/p>\nRefer to these articles:<\/p>\n
\n- Importing previously exported repository data into Oracle Server Database step_by_step<\/a><\/li>\n
- Importing previously exported repository data into SQL Server Database step by step<\/a><\/li>\n<\/ul>\n
3. Run the Export\/Import utility on the same computer on which the database is running. Choose the option to Import data.<\/p>\n
4. Restart TopTeam\/Visual Use Case Application Server<\/i>.<\/p>\n<\/div>\n<\/div>\n\nIMPORTANT:<\/h3>\n\n\n- You need to optimize the database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/li>\n
- Run “Resync Tab-indicators” from Desktop App<\/i> to resynchronize tab indicators throughout the system.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Step 5. Run “Resync Tab-indicators” from Desktop App<\/h3>\n<\/div>\n<\/div>\n\nSee Also<\/h3>\n\nImporting previously exported repository data into SQL Server Database step-by-step<\/a>
\nExporting repository data from Firebird Database step_by_step<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 8th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Background TechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository. Overview This article explains how to migrate data repository from one database type to another database type. For example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc. Who should read this? TopTeam or Visual Use Case Administrators IT Support Database Administrators Process Overview Export data from existing database using the Export utility provided by TechnoSolutions. Perform a <\/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,43,295],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-migrate","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-BQ","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346","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=2346"}],"version-history":[{"count":29,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions"}],"predecessor-version":[{"id":49542,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions\/49542"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
This article explains how to migrate data repository from one database type to another database type.
\nFor example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc.<\/p>\n<\/div>\n<\/div>\n
Who should read this?<\/h3>\n\n\n- TopTeam or Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Process Overview<\/h3>\n\n\n- Export data <\/strong>from existing database using the Export utility provided by TechnoSolutions.<\/li>\n
- Perform a new installation <\/strong>of TopTeam Application Server<\/i> (or Visual Use Case Application Server<\/i>) for the new database type.<\/li>\n
- Import data<\/strong> from Step 1 into the new database using the Import utility provided by TechnoSolutions.<\/li>\n
- Move “User Data Files”<\/strong> from existing Application Server to the corresponding folder of the new Application Server.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Preparations<\/h3>\n\n1. Ensure that TechnoSolutions’ Export utility<\/strong> <\/i>for the existing database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n2. Ensure that TechnoSolutions’ Import utility<\/strong> <\/i>for the new database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n3. The TopTeam Application Server installer<\/strong><\/i> for the new database type (unless this is already installed).
\nRefer to the following appropriate article for TopTeam Application Server<\/i>:
\na. Firebird – Installing TopTeam Application Server for Firebird<\/a>
\nb. Oracle – Installing TopTeam Application Server for Oracle<\/a>
\nc. SQL Server – Installing TopTeam Application Server for SQL Server<\/a><\/p>\n4. License Key and License Files<\/strong><\/i> for the new database type (Each database type requires a different set of Keys and Files for TopTeam<\/i> or Visual Use Case<\/i>).
\nRefer to the article How to register and load License Files in TopTeam using Management Console.<\/a><\/p>\n5. Username and Password to access the repository schema in the existing database<\/strong><\/i> (so that the Export utility can connect to the current database).<\/p>\n6. Username and Password to access the repository schema in the new database<\/strong><\/i> (so that the Import utility can connect to the new database).<\/p>\nTechnoSolutions repository Import\/Export utilities and Application Server<\/i> installers are available from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n\nStep 1. Install new TopTeam Application Server<\/h3>\n\nInstall new TopTeam Application Server<\/i> and DB Schema on the new (destination) database and apply the license keys.<\/p>\n
Refer to the following related articles:<\/p>\n
\n- Installing TopTeam Application Server for Firebird<\/a><\/li>\n
- Installing TopTeam Application Server for Oracle<\/a><\/li>\n
- Installing TopTeam Application Server for SQL Server<\/a><\/li>\n
- How to register and load License Files in TopTeam using Management Console<\/a><\/li>\n<\/ul>\n
For example: If you are moving from Firebird to MS SQL Server, you would install TopTeam\/Visual Use Case Application Server <\/i>for MS SQL Server.<\/p>\n
NOTE:<\/strong><\/p>\n\n- There is NO need to configure<\/i><\/strong> users and other application configuration on the new destination database. When you migrate from the existing database, all data, configuration settings etc. will be carried over and ANY repository related data in the new (destination) database will be overwritten.<\/li>\n
- The Repository DB Schema<\/i> version of the existing database must match the DB Schema version of the new database. Repository Schema<\/i> versions are specified as 3.2, 4.8, etc.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Step 2. Export data from existing database<\/h3>\n\nFollow these steps to export repository data from the existing database:<\/p>\n
1. Stop and exit from existing TopTeam Application Server<\/i>.<\/p>\n
2. Download the TopTeam Export\/Import utility corresponding to the existing database.<\/p>\n
For example: If you are moving from Firebird to MS SQL Server, your existing database is Firebird. You then need the TopTeam Firebird Database Export\/Import utility<\/i>.
\nFor Firebird – Use Username and Password as sysdba<\/strong><\/i> and masterkey<\/i><\/strong><\/p>\n3. Run the Export\/Import utility<\/i> on the computer where the database is running, choose the option to Export<\/i><\/strong> data<\/strong><\/i>.<\/p>\nThis will export the TopTeam\/Visual Use Case <\/i>data into a number of intermediate files.<\/p>\n<\/div>\n<\/div>\n\nStep 3. Migrate data<\/h3>\n\n1. If moving to a new computer, copy the exported data files (generated in Step 2. above) to the new computer.<\/p>\n
2. Copy “User Data Files” to the corresponding location of the new Application Server.<\/p>\n
The default location<\/strong> of the User Data Files<\/i> is:
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files – Sample<\/p>\n<\/div>\n<\/div>\n\nStep 4. Run the Import utility to import data into the new database<\/h3>\n\n1. Stop and exit from the new TopTeam Application Server<\/i>, if running.
\n(i.e. Ensure that the new TopTeam Application Server<\/i> is NOT running<\/strong>).<\/p>\n2. Download the TopTeam Export\/Import <\/i>utility corresponding to your destination database. (Download the Export\/Import utility from the TechnoSolutions Customer Portal<\/a>).<\/p>\nFor example: If you are moving from Firebird to MS SQL Server, your target database is SQL Server, so you would need the TopTeam SQL Server Database Export\/Import<\/i> utility.
\nNOTE: You will need a valid Username and Password for SQL Server.<\/strong><\/p>\nRefer to these articles:<\/p>\n
\n- Importing previously exported repository data into Oracle Server Database step_by_step<\/a><\/li>\n
- Importing previously exported repository data into SQL Server Database step by step<\/a><\/li>\n<\/ul>\n
3. Run the Export\/Import utility on the same computer on which the database is running. Choose the option to Import data.<\/p>\n
4. Restart TopTeam\/Visual Use Case Application Server<\/i>.<\/p>\n<\/div>\n<\/div>\n\nIMPORTANT:<\/h3>\n\n\n- You need to optimize the database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/li>\n
- Run “Resync Tab-indicators” from Desktop App<\/i> to resynchronize tab indicators throughout the system.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n\n
Step 5. Run “Resync Tab-indicators” from Desktop App<\/h3>\n<\/div>\n<\/div>\n\nSee Also<\/h3>\n\nImporting previously exported repository data into SQL Server Database step-by-step<\/a>
\nExporting repository data from Firebird Database step_by_step<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 8th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Background TechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository. Overview This article explains how to migrate data repository from one database type to another database type. For example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc. Who should read this? TopTeam or Visual Use Case Administrators IT Support Database Administrators Process Overview Export data from existing database using the Export utility provided by TechnoSolutions. Perform a <\/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,43,295],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-migrate","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-BQ","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346","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=2346"}],"version-history":[{"count":29,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions"}],"predecessor-version":[{"id":49542,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions\/49542"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- TopTeam or Visual Use Case Administrators<\/li>\n
- IT Support<\/li>\n
- Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n
Process Overview<\/h3>\n
\n- \n
- Export data <\/strong>from existing database using the Export utility provided by TechnoSolutions.<\/li>\n
- Perform a new installation <\/strong>of TopTeam Application Server<\/i> (or Visual Use Case Application Server<\/i>) for the new database type.<\/li>\n
- Import data<\/strong> from Step 1 into the new database using the Import utility provided by TechnoSolutions.<\/li>\n
- Move “User Data Files”<\/strong> from existing Application Server to the corresponding folder of the new Application Server.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n
\nPreparations<\/h3>\n
\n1. Ensure that TechnoSolutions’ Export utility<\/strong> <\/i>for the existing database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n
2. Ensure that TechnoSolutions’ Import utility<\/strong> <\/i>for the new database type is downloaded from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) and is available for use.<\/p>\n
3. The TopTeam Application Server installer<\/strong><\/i> for the new database type (unless this is already installed).
\nRefer to the following appropriate article for TopTeam Application Server<\/i>:
\na. Firebird – Installing TopTeam Application Server for Firebird<\/a>
\nb. Oracle – Installing TopTeam Application Server for Oracle<\/a>
\nc. SQL Server – Installing TopTeam Application Server for SQL Server<\/a><\/p>\n4. License Key and License Files<\/strong><\/i> for the new database type (Each database type requires a different set of Keys and Files for TopTeam<\/i> or Visual Use Case<\/i>).
\nRefer to the article How to register and load License Files in TopTeam using Management Console.<\/a><\/p>\n5. Username and Password to access the repository schema in the existing database<\/strong><\/i> (so that the Export utility can connect to the current database).<\/p>\n
6. Username and Password to access the repository schema in the new database<\/strong><\/i> (so that the Import utility can connect to the new database).<\/p>\n
TechnoSolutions repository Import\/Export utilities and Application Server<\/i> installers are available from the TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers).<\/p>\n<\/div>\n<\/div>\n
\nStep 1. Install new TopTeam Application Server<\/h3>\n
\nInstall new TopTeam Application Server<\/i> and DB Schema on the new (destination) database and apply the license keys.<\/p>\n
Refer to the following related articles:<\/p>\n
- \n
- Installing TopTeam Application Server for Firebird<\/a><\/li>\n
- Installing TopTeam Application Server for Oracle<\/a><\/li>\n
- Installing TopTeam Application Server for SQL Server<\/a><\/li>\n
- How to register and load License Files in TopTeam using Management Console<\/a><\/li>\n<\/ul>\n
For example: If you are moving from Firebird to MS SQL Server, you would install TopTeam\/Visual Use Case Application Server <\/i>for MS SQL Server.<\/p>\n
NOTE:<\/strong><\/p>\n
- \n
- There is NO need to configure<\/i><\/strong> users and other application configuration on the new destination database. When you migrate from the existing database, all data, configuration settings etc. will be carried over and ANY repository related data in the new (destination) database will be overwritten.<\/li>\n
- The Repository DB Schema<\/i> version of the existing database must match the DB Schema version of the new database. Repository Schema<\/i> versions are specified as 3.2, 4.8, etc.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
\nStep 2. Export data from existing database<\/h3>\n
\nFollow these steps to export repository data from the existing database:<\/p>\n
1. Stop and exit from existing TopTeam Application Server<\/i>.<\/p>\n
2. Download the TopTeam Export\/Import utility corresponding to the existing database.<\/p>\n
For example: If you are moving from Firebird to MS SQL Server, your existing database is Firebird. You then need the TopTeam Firebird Database Export\/Import utility<\/i>.
\nFor Firebird – Use Username and Password as sysdba<\/strong><\/i> and masterkey<\/i><\/strong><\/p>\n3. Run the Export\/Import utility<\/i> on the computer where the database is running, choose the option to Export<\/i><\/strong> data<\/strong><\/i>.<\/p>\n
This will export the TopTeam\/Visual Use Case <\/i>data into a number of intermediate files.<\/p>\n<\/div>\n<\/div>\n
\nStep 3. Migrate data<\/h3>\n
\n1. If moving to a new computer, copy the exported data files (generated in Step 2. above) to the new computer.<\/p>\n
2. Copy “User Data Files” to the corresponding location of the new Application Server.<\/p>\n
The default location<\/strong> of the User Data Files<\/i> is:
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files
\nC:\\Program Files\\TechnoSolutions TopTeam\\Application Server for <>\\User Data Files – Sample<\/p>\n<\/div>\n<\/div>\n\nStep 4. Run the Import utility to import data into the new database<\/h3>\n
\n1. Stop and exit from the new TopTeam Application Server<\/i>, if running.
\n(i.e. Ensure that the new TopTeam Application Server<\/i> is NOT running<\/strong>).<\/p>\n2. Download the TopTeam Export\/Import <\/i>utility corresponding to your destination database. (Download the Export\/Import utility from the TechnoSolutions Customer Portal<\/a>).<\/p>\n
For example: If you are moving from Firebird to MS SQL Server, your target database is SQL Server, so you would need the TopTeam SQL Server Database Export\/Import<\/i> utility.
\nNOTE: You will need a valid Username and Password for SQL Server.<\/strong><\/p>\nRefer to these articles:<\/p>\n
- \n
- Importing previously exported repository data into Oracle Server Database step_by_step<\/a><\/li>\n
- Importing previously exported repository data into SQL Server Database step by step<\/a><\/li>\n<\/ul>\n
3. Run the Export\/Import utility on the same computer on which the database is running. Choose the option to Import data.<\/p>\n
4. Restart TopTeam\/Visual Use Case Application Server<\/i>.<\/p>\n<\/div>\n<\/div>\n
\nIMPORTANT:<\/h3>\n
\n- \n
- You need to optimize the database that has been created\/migrated to ensure proper performance. Refer to the article Tuning TopTeam Database Performance<\/a>.<\/li>\n
- Run “Resync Tab-indicators” from Desktop App<\/i> to resynchronize tab indicators throughout the system.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n
\nStep 5. Run “Resync Tab-indicators” from Desktop App<\/h3>\n
\nSee Also<\/h3>\n
\nImporting previously exported repository data into SQL Server Database step-by-step<\/a>
\nExporting repository data from Firebird Database step_by_step<\/a><\/p>\n<\/div>\n<\/div>\n\n\nRevised: September 8th, 2016<\/p>\n<\/div>\n<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Background TechnoSolutions’ products TopTeam(TM), Visual Use Case(TM), etc. store repository artifacts in a database. You can use Microsoft SQL Server, Oracle or Firebird Open Source databases to host this repository. Overview This article explains how to migrate data repository from one database type to another database type. For example, you can migrate data repository from Firebird DB (Database) to Microsoft SQL Server DB, from Firebird DB to Oracle DB, etc. Who should read this? TopTeam or Visual Use Case Administrators IT Support Database Administrators Process Overview Export data from existing database using the Export utility provided by TechnoSolutions. Perform a <\/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,43,295],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-migrate","tag-repository"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-BQ","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346","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=2346"}],"version-history":[{"count":29,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions"}],"predecessor-version":[{"id":49542,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2346\/revisions\/49542"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Run “Resync Tab-indicators” from Desktop App<\/i> to resynchronize tab indicators throughout the system.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n
- Importing previously exported repository data into SQL Server Database step by step<\/a><\/li>\n<\/ul>\n
- The Repository DB Schema<\/i> version of the existing database must match the DB Schema version of the new database. Repository Schema<\/i> versions are specified as 3.2, 4.8, etc.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
- Installing TopTeam Application Server for Oracle<\/a><\/li>\n
- Perform a new installation <\/strong>of TopTeam Application Server<\/i> (or Visual Use Case Application Server<\/i>) for the new database type.<\/li>\n
- Export data <\/strong>from existing database using the Export utility provided by TechnoSolutions.<\/li>\n