$customHeader
Skip to end of banner
Go to start of banner

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

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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":
  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:


  • No labels