KB : How to access (view) SQL Server CE database file from TFS4JIRA Synchronizer

Windows instructions

1. Download & install Microsoft SQL Server Compact 4.0 https://www.microsoft.com/en-us/download/confirmation.aspx?id=17876.

2. Download & install LINQPad 4 for .NET Framework 4.0 / 4.5.

3. Copy your C:\inetpub\wwwroot\tfs-jira-synchronizer\App_Data\config.sdf file somewhere else inside your machine – you cannot connect to the database if it's active (assuming your TFS4JIRA Synchronizer is running).

4. Open up LINQPad and click "Add connection":
   
   

   Open

   

5. Select Build data context automatically and Default (LINQ to SQL) and click "Next":
   
   

   Open

   

6. Select SQL CE 4.0 under "Provider" and browse the config.sdf file (the one you've copied in step 3) under "Database":
   
   

   Open

   

7. You don't need to change anything else. Click "Test" and make sure you get a "Connection Successful" message:
   
   

   Open

   

8. After that "Ok" and you should be able to browse through the database:
   
   

   Open