Improve performance over remote connections
We have a team that works remotely so no local network access to source control, only access over the internet. Sometimes I cannot get latest or commit anything because most of the time the source window is stuck on "Determining latest version". I've let it run for a few hours with no luck. It is a relatively large database with around 2000 objects, 1000 stored procedures which have a total size of 4.3MB text.
A SQL Compare snapshot of this database is 23MB or 6.5MB compressed.
What about having an intermediate service which runs on same local network as source control that can accept compressed data from remote locations? I'm not sure if SQL source control checks object by object but perhaps this intermediate service can return a compressed packaged snapshot from source control as 1 response to SQL Source Control in order to determine the changes?
Johannes
shared this idea
-
Johannes
commented
Hi Jason, since this suggestion our team moved over to Git and we're hosting the databases source code in GitHub. This works very well with remote teams and you may consider looking into it.
-
Johannes
commented
Hi Jason, since this suggestion our team moved over to Git and we're hosting the databases source code in GitHub. This works very well with remote teams and you may consider looking into it.
-
Jason
commented
This is crucial for our organization to get adoption by our offsite and overseas developers. I posted some findings in the forums that I hope will help: