Page Comparison

In this article, you can find instructions on setting up the environment to use the TFS4JIRA synchronizer app installed in a different machine/server of the database, in this case, MS-SQL DB.

...

1. Initially, on Server-1, install Microsoft® SQL Server® Compact 4.0 SP1 - download link:https://www.microsoft.com/en-us/download/details.aspx?id=30709 in the synchronizer application server (Server-1).

2. INSTALLATION OF TFS4JIRA STEPS HERE ON SERVER-1Installation of tfs4jira steps here on server-1
   https://appfire.atlassian.net/wiki/spaces/TFS4JIRA/pages/148193439/Installation

3. Next, open tfs-jira-synchronizer using http://localhost/tfs-jira-synchronizer. If the synchronizer is opened, Install the Export SQLCe tool on Server-1.

4. Stop the TFS4Jira Synchronizer application pool in IIS on Server-1.

5. Export SQL CE db into a .sql script (schema and data) on Server-1.

6. On Server-1run the command: C:\Users\Administrator\Downloads\ExportSqlCe40.exe "Data Source=C:\inetpub\wwwroot\tfs-jira-synchronizer\App_Data\config.sdf" Synchronizer.sql in the directory where you downloaded the export SQLCE tool (it requires opening the terminal as administrator).

7. Once the command is executed, the Synchronizer.sql file is created in path C:\inetpub\wwwroot\tfs-jira-synchronizer\App_Data\.

8. Now on Server-2, create a new DB in MSSQL using the below script.

...