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

Owned by Paweł Mazur
Last updated: May 17, 2022 by Damian Kilkowski (Inactive) (Deactivated)
2 min read

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 5 for .NET Framework 4.6/4.7/4.8 (in case of obsolete link please download the current version from: https://www.linqpad.net/Download.aspx)
  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":
  5. Select Build data context automatically and Default (LINQ to SQL) and click "Next":
  6. Select SQL CE 4.0 under "Provider" and browse the config.sdf file (the one you've copied in step 3) under "Database":
  7. You don't need to change anything else. Click "Test" and make sure you get a "Connection Successful" message:
  8. After that "Ok" and you should be able to browse through the database: