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

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

Owned by Paweł Mazur

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:


Related content