| Info |
|---|
Please reach out to Appfire support in case of any questions or issues concerning the below manual. Contact details: Need support ? |
Prerequisites:
- Latest TFS4JIRA Self-Hosted version - download
- Install SQL Express (steps below)
- Install Export SQLCe tool
- (optional) Install SQL Server Management Studio (SMSS)
SQL EXPRESS 2019 installation
- Download the installer for your system: SQL Express
- Start CUSTOM installation
- Choose: New SQL Server stand-alone installation or add features to an existing installation
- (optional) - do not install Machine Learning Services
- Named instance: TFS4JIRA
- Collation: SQL_Latin1_General_CP1_CI_AS
- Authentication mode: Mixed mode
- SA password: <password>
- please setup a custom, strong password
- some Windows systems require strong passwords via Group Policy
...
| Info |
|---|
Users may choose to run the scripts provided below using SQL Server Management Studio (SMSS) instead of SQLCMD commands. |
...
Export SQL CE database into an .sql script (schema and data)
- Download Export SQLCe tool (unzip to find .exe file)
Run the following command in the directory where you have downloaded Export SQLCe tool (remember to start terminal as the administrator):
Code Block language actionscript3 theme RDark ExportSqlCe40.exe "Data Source=C:\<tfs4jira synchronizer installation directory>\App_Data\config.sdf;Max Database Size=4000;" Synchronizer_SQLCE_DB.sql
Info When the resulting script size exceeds 18,528 KB, ExportSqlCe40.exe tool automatically breaks down the output files into chunks with index numbers. Check the table below for the expected output and run time:
config.sdf file size
# of chunks / .sql file count
Total size of .sql scripts
Data migration duration
787 MB
75
1.31 GB
~1.5 hour
1.53 GB
149
2.62 GB
~2.5 hour
3.05 GB
298
5.25 GB
~5 hours
- Outcome example
- (optional) Ppen generated file using SSMS and make sure that file is not empty, you should see SQL commands creating schema and adding data in file.
Create new DB in SQLExpress
...
Start TFS4Jira Synchronizer application pool in IIS
MIGRATION VALIDATION
In order to validate that TFS4JIRA Synchronizer uses SQL Express you can add a new profile or rename one of the existing ones. After that please query "SyncProfiles" using below command
| Code Block | ||||
|---|---|---|---|---|
| ||||
sqlcmd -S localhost\TFS4JIRA -d TFS4JIRA -q "select * from SyncProfiles" -E -e > DB_migration_validation.txt |
You should see your changes in DB_migration_validation.txt. Example content:
ROLLBACK
In case something goes wrong or there will be problems with SQLExpress database, you can always go back to use SQL CE database. In order to do so follow this steps:
...
| Info |
|---|
Please reach out to Appfire support in case of any questions or issues concerning below manual. Contact details: Need support ? |
Prerequisites:
- Install SQL Express (steps below)
- Install Export SQLCe tool
- (optional) Install SQL Server Management Studio (SMSS)
SQL EXPRESS 2019 installation
- Download the installer for your system: SQL Express
- Start CUSTOM installation
- Choose: New SQL Server stand-alone installation or add features to an existing installation
- (optional) - do not install Machine Learning Services
- Named instance: TFS4JIRA
- Collation: SQL_Latin1_General_CP1_CI_AS
- Authentication mode: Mixed mode
- SA password: <password>
- please setup a custom, strong password
- some Windows systems require strong passwords via Group Policy
...
| Info |
|---|
Users may choose to run the scripts provided below using SQL Server Management Studio (SMSS) instead of SQLCMD commands. |
...
Export SQL CE database into an .sql script (schema and data)
- Download Export SQLCe tool (unzip to find .exe file)
Run the following command in the directory where you have downloaded Export SQLCe tool (remember to start terminal as the administrator):
Code Block language actionscript3 theme RDark ExportSqlCe40.exe "Data Source=C:\<tfs4jira synchronizer installation directory>\App_Data\config.sdf;Max Database Size=4000;" Synchronizer_SQLCE_DB.sql
Info When the resulting script size exceeds 18,528 KB, ExportSqlCe40.exe tool automatically breaks down the output files into chunks with index numbers. Check the table below for the expected output and run time:
config.sdf file size
# of chunks / .sql file count
Total size of .sql scripts
Data migration duration
787 MB
75
1.31 GB
~1.5 hour
1.53 GB
149
2.62 GB
~2.5 hour
3.05 GB
298
5.25 GB
~5 hours
- Outcome example
- (optional) Ppen generated file using SSMS and make sure that file is not empty, you should see SQL commands creating schema and adding data in file.
Create new DB in SQLExpress
...
Start TFS4Jira Synchronizer application pool in IIS
MIGRATION VALIDATION
In order to validate that TFS4JIRA Synchronizer uses SQL Express you can add a new profile or rename one of the existing ones. After that please query "SyncProfiles" using below command
| Code Block | ||||
|---|---|---|---|---|
| ||||
sqlcmd -S localhost\TFS4JIRA -d TFS4JIRA -q "select * from SyncProfiles" -E -e > DB_migration_validation.txt |
You should see your changes in DB_migration_validation.txt. Example content:
ROLLBACK
In case something goes wrong or there will be problems with SQLExpress database, you can always go back to use SQL CE database. In order to do so follow this steps:
...