Simplify datalink source code repository migration
We recently migrated our svn repo to HTTPS and part of that process was for our devs to update their SQL Source Control datalinks.
We ran into 4 issues:
1) When opening SSMS for the first time, we were inundated by SQL Source Control to update our credentials.
2) After hitting cancel 10 times, we were able to get to the Setup tab. Where we thought we could just edit the existing link, but instead we had to Unlink the database first.
3) After unlinking, all the options on the Setup tab disappeared requiring a restart of SSMS. I can provide a screenshot if that would be useful.
4) Then while linking it hung at 10% for a really long time, even though we could see data going back and forth to the svn server using Resource Monitor.
After that it was clear sailing.
Iain Elder commented
I proposed a solution to issue 1 here in my new suggestion: http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/5739758-suppress-credentials-prompt-when-ssms-starts