Thanks for your post. In regards to your particular question about migrating the history and source control contents of your TFS repository, we do not have any specific recommendations on the actual migration of the repo contents as this is something specific to the TFS backend. Here are some links to help get you started on the migration within TFS:
http://stackoverflow.com/questions/6776 ... to-another
When working in SQL Source Control, the following steps are recommended for your situation:
- unlink the affects DB's prior to the repo move
- Make the change in repo location
- Once the repo is located at it's new location: relink the affected DB's in SSMS
(The relinking will rebuild the underlying working base and transient folders on the local machine where SQL Source Control is installed)
The important part to note is that the history of the changes is read from TFS directly, so if the history is lost within the actual source control backend, SQL Source Control will not be able to read in the history. Hope this helps a little.