SQL Source Control
Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.
If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.
To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates
-
Newly added objects no longer have a blue ball beside it in the object explorer unless I do a refresh from the SQL Source Control tab.
Connecting to a Subversion repository SQL Source Control used to refresh the Object Explorer and show newly added items at the bottom of the list with a blue ball next to it. Since the last version update, I have to manually refresh the Object Explorer to get the newly added item to show up and there is no blue ball next to it unless open SQL Source Control and hit refresh there.
1 vote -
Microsoft Data Project Support
Allow users to bind Red Gate Source Control in SSMS to a VS Data Project. This would provide an elegant State Based Solution complete with corresponding Visual Studio Project Template
3 votes -
command line to view all uncommited changes so that we can email a report of all uncommited chnages
It will be helpful to see or email a report of all uncommited changes by a developer so that we can take actions accordingly
3 votes -
auto complete suggestion context
if I am adding an "AND" condition to a join or where clause and I type the letter "A", SQL Prompt will have "Alter" as the first suggestion, followed by "ADD", and then "AND". The first two suggestions are not valid in the syntax for a join condition or where clause so I don't understand why they are even suggested, or why "AND" isn't at the top of the list.
3 votes -
Link to Git does not allow text entry on 2nd DB
When linking a 2nd (and all subsequent) database to Git - the text entry for the folder is locked (cannot type into it)
1 vote -
Support from Red-Gate SQL Backup command line tools on linux for sql server
Title describes it
4 votes -
Would be nice to see what filtered objects are under source control (even if they are committed)
When using filters in SQL Server it would be nice to see what objects are under source control (even if they are committed, maybe with a yellow dot). Currently only uncommitted objects under source control are indicated.
1 vote -
allow to select/unselect dependent objects on commit
On commit, there is a button to select/unselect all dependent objects. It would be good to have select/unselect basically a check box to tick or untick the dependent object. This will allow me to select specific dependent object I wish to control not all.
1 vote -
filter
Allow object types same as that of SQL server database objects. Example, I would like to include some functions under "Table-Valued functions" under the object type "Function". It would be good if there is a tree structure for each object type same as that of SQL server database structure.
1 vote -
SourceControl occupies gigabtyes of old files
Today, my Windows C: device was 99% full. During the search of the biggest files (which were the Windows/assembly/ folder) I noticed gigabytes of SQL Source Control files! Back to Source Control Version 3.x and 4.x even though we already updated to 5.x. Source Control does not clean up old files.
Directories I found old Source Control files:
C:\Windows\Downloaded Installations\
C:\ProgrammData\Downloaded Installations\
C:\Users\...\AppData\Local\Red Gate\Please provide a function do uninstall all those old files that occupy even gigabytes of disk space storage. Thank you!
7 votes -
Add 'Work Item Number' to the History screen for TFS users
Add a column in the results for TFS customers so that they can see what Work Item was associated with the changeset
4 votes -
See incremental changes made before committing
When working with an object, there is a chance that another developer has made modifications as well since many developers work off of the same database.
When committing, it would be nice to be able to see a history of modifications. Each time an object is modified (F5) take a commitable snapshot of that object.
When a developer goes to commit, they could see the different times an object was modified and commit all at one time or commit the individual changes made over time. Doing a commit will roll-up all previous commits made.
Example:
Day 1: Dev A: Adds…14 votes -
Option to use modification date as the commit date
With SQL, when you modify an object, that object is now out there to be used or tweaked by other developers. Committing it is really just a statement of, I'm done working with this object and here's what I've done.
We have the problem of not committing objects as timely as we should. We make a modification and go our way until we realize a week later, we forgot to commit. So we commit, but the date time stamp of the commit is not helpful. That is just when the developer remembered.
I think it would be much, much more…
8 votes -
Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users
Feature which should enforce user to lock the object before editing when administrator enables the restrictive policy for the users
If it is there it will be very much helpful for most of the development projects not testing and production.
1 vote -
Data warehouses need source control too! (Azure SQL Data Warehouse / PDW)
Add source control support for Azure SQL Data Warehouse. I'd love to be able to source control my data warehouse schema.
12 votes -
1 vote
-
history rename
Treat object RENAME as Source Control (TFS) file RENAME not Drop & Add which deletes Source Control history of the object/file
More details can be found here: https://redgatesupport.zendesk.com/hc/en-us/requests/88809
58 votes -
Keeps detecting changes for value s'
Hello,
I have a table with only one PK column of type nvarchar(200) which contains static data.
Source Control keeps telling that there are changes even after saving the changes. It seems that it has some issues with the value s'Database version:
-- Only In DatabaseINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
-- Identical
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan')
INSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'aan de')Latest source control version:
-- Only In Source ControlINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N's''')
-- IdenticalINSERT INTO [dbo].[tab_54_Voorvoegsels] ([Voorvoegsel]) VALUES (N'a')
INSERT INTO [dbo].[tab_54_Voorvoegsels]…3 votes -
Ability push database linking of database to team members
When using a shared database development model having a location which allows you see which developers have linked to the database. Also having the ability to be able to push out the linking to the database to developers from a central point
5 votes -
A way to select the database from the tab itself.
I develop and have to switch between multiple databases and the source control tab keeps following the database I am on. When I want to commit changes I have to stay put otherwise I keep losing the progress looking for changes. It would be nice to have the option of which database we are looking at from the tab itself, instead of from the SQL Management Studio one
10 votes
- Don't see your idea?