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
- Download & install Microsoft SQL Server Compact 4.0 https://www.microsoft.com/en-us/download/confirmation.aspx?id=17876.
- Download & install LINQPad 4 for .NET Framework 4.0 / 4.5.
- 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).
- Open up LINQPad and click "Add connection":
![](https://appfire.atlassian.net/wiki/download/thumbnails/153453625/Screen%20Shot%202018-08-24%20at%2010.13.06.png?version=1&modificationDate=1608295980667&cacheVersion=1&api=v2&width=402&height=250)
- Select Build data context automatically and Default (LINQ to SQL) and click "Next":
![](https://appfire.atlassian.net/wiki/download/thumbnails/153453625/Screen%20Shot%202018-08-24%20at%2010.14.18.png?version=1&modificationDate=1608295980478&cacheVersion=1&api=v2&width=402&height=250)
- Select SQL CE 4.0 under "Provider" and browse the config.sdf file (the one you've copied in step 3) under "Database":
![](https://appfire.atlassian.net/wiki/download/thumbnails/153453625/Screen%20Shot%202018-08-24%20at%2010.15.34.png?version=1&modificationDate=1608295980300&cacheVersion=1&api=v2&width=402&height=250)
- You don't need to change anything else. Click "Test" and make sure you get a "Connection Successful" message:
![](https://appfire.atlassian.net/wiki/download/thumbnails/153453625/Screen%20Shot%202018-08-24%20at%2010.16.12.png?version=1&modificationDate=1608295980106&cacheVersion=1&api=v2&width=402&height=250)
- After that "Ok" and you should be able to browse through the database:
![](https://appfire.atlassian.net/wiki/download/thumbnails/153453625/Screen%20Shot%202018-08-24%20at%2010.17.42.png?version=1&modificationDate=1608295979919&cacheVersion=1&api=v2&width=402&height=250)