8 results found
-
Add SSH key support for push/pull to remote Git repository.
When using the 'Push to remote Git repository' feature in SC 4.1.8.41, add functional support for remote Git repositories that use SSH keys for authentication.
89 votesSQL Source Control 7 has now been released. In this version, SQL Source Control now uses the Git command line for all its Git interactions, which means it will support any Git authentication method that the command line supports. This includes SSH support. You’ll need to make sure you have your SSH key correctly configured for the Git command line to use.
You will need to ensure that you have Git.exe available in your system path – the easiest way to do this if you don’t already have Git installed is to download Git for windows (https://git-scm.com/download/win)
-
Fix for error msg: "SQL Source Control is disabled because you have multiple instances of SSMS open".
When other instances of SSMS are closed, Source Control should be re-enabled.
1 voteIn the Global Options you can choose to allow SQL Source Control to be open in multiple Management Studio windows
-
Support for SEQUENCE object
Sequence object not yet recognized by SQL Source Control.
14 votesSequence objects should have started working from v3.6 onwards – please email support@red-gate.com if you are still having difficulties with this object type.
-
On a shared model, the Changed By column says unknown for some uncomitted changes on the Commit List
When I try to commit changes it says unknown user. I believe it is very important to be able to track who's making what changes.
112 votesIn v3.1, we store user information when an object changes so you don’t see “unknown” on the commit list for changes on a shared model. Details are at https://documentation.red-gate.com/display/SOC32/Logging+changes+to+shared+databases
-
Make RedGateDatabaseInfo.xml easier to merge
When we look at the RedGateDatabaseInfo.xml file, it appears as one long line of text. Merging this is nigh on impossible because the one line conflicts. It would be nice if it was written in a pretty xml format to help with merging
3 votesForm Source Control version 2.1, RedGateDatabaseInfo.xml should now be in a more structured format.
Please comment on this suggestion if this new structure does not meet your requirements.
Please visit our product page for more information on the latest version of SQL Source Control:
http://www.red-gate.com/products/sql-development/sql-source-control/ -
Show or Filter By User who last updated on Commit List for Shared (Centralized) DB Model
One of the problems with a shared db model, where all developers work against the same database, is that everyone's changes are listed on the Commit List. It would be nice if only my changes were shown. There should be someway to filter the list to just my changes, or at least show the username in a column so that it can be sorted on.
9 votesThis feature is included in SQL Source Control v2.0, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
If you setup your database as shared, then you will see who last updated each object on the Commit tab and Undo dialog. Only objects that you last updated will be checked by default.
NOTE: Databases linked in v1 default to dedicated databases. You will need to relink your databases to switch development models.
-
Don't show conflicts when working in a Shared (Centralized) DB Model
In a dedicated db model, a conflict will occur when User1 and User2 both make a change to Table1. User1 commits the change successfully. When User2 tries to commit, they will be notified of the conflict. User2 must then decide if they want to take what's in source control or keep their version and commit this to source control. In either case, User2 may need to reapply some changes to the db and re-commit.
In a centralized db model, when all developers are working against the same db, these conflicts should NOT occur.
10 votesThis feature is included in SQL Source Control v2.0, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
This is a known issue in v1 because the underlying working folder is per user and is NOT shared…
NOTE: Databases linked in v1 default to dedicated databases. You will need to relink your databases to switch development models.
-
Dedicated DB VS Shared (Centralized) DB Model
I recentrly had a brief email exchange with Stephanie from Red Gate, where I explained that we use a centralized Development database, instead of every developer having a dedicated local version of the DB against which they develop. I believe that the Centralized Dev DB model is the model used most in the field, mainly for two reasons. 1) Most companies don't want their developers to have local copies of the database for security reasons, and 2) Development DBs often hold a lot of test data which would not be practical for all of the developers to have locally.
Having…
3 votesSQL Source Control supports either model, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
v2.0 has the following enhancements for the shared model:
If you setup your database as shared, then you will see who last updated each object on the Commit tab and Undo dialog. Only objects that you last updated will be checked by default. This will prevent you from accidentally committing/undoing others changes that work on the same db.We are also addressing the problem so that you will no longer see invalid conflicts on the Commit tab.
- Don't see your idea?