Stand-alone app
I'd suggest rebuilding Red Gate SQL Source Control into a stand-alone application (similar to SQL Compare & SQL Data Compare), instead of a plug-in to SSMS.
My SSMS has gotten awfully slow since installing SQL Source Control, even after unchecking the Changed Object & Static Data control options, AND setting EnableObjectLocking to FALSE under the hood.
Consider that I'm working all day in SSMS, but I only need SQL Source Control maximum once or twice a day, when committing changes to Git.
Kind regards,
Christof
Anonymous
shared this idea
The next version of SQL Source Control will be merged into Flyway. Flyway Desktop is a standalone application and provides versioning for over 20 RDBMS. You can learn more about transitioning from SQL Source Control to Flyway at https://documentation.red-gate.com/fd/sql-source-control-164167857.html.
-
Anonymous
commented
Did you try to disable the code analysis? When you are working onto bigger scripts (e.g. > 1000 lines) SSMS becomes really slow / unusable when the code analysis is enabled :-(
@David Atkinson: is there already a standalone SourceControl?
-
Christof Colle
commented
@David Atkinson, I'm very interested. I wouldn't care if the stand-alone still has some performance concerns. As long as I can continue using SSMS without any slowdowns...
-
Christof Colle
commented
Actually this was an idea I posted, before having registered my account properly.