588 results found
-
Additional Control of what constitutes a commitable change
Ignore names generated by SQL Server (such as Primary Keys, Defaults etc)
3 votes -
BUG: Sql Source control doesn't maintain WITH (IGNORE_DUP_KEY=ON) on table type
I have a table type with "(IGNOREDUPKEY=ON)" on it. Sql Source control doesn't preserve this and doesn't see this in the SqlServer database schema on the table type
3 votes -
Default Check-in Comments
It should be possible to configure default check-in comments for setting up WorkItem-Codes. We got one specific work item for database changes. So a developer doesn't need to type the code manually or has select it from previous check-ins.
3 votes -
Database name flickering in Object Explorer
Version 3.5.3.29
SSMS 2008 Express, connected to local 2005 Express instance, running on Windows 7 as a guest within VMWare Workstation.As standard I have all my databases offline, and bring them online individual as and when required.
The database name in the Object Explorer shows the "spinning" white and blue dot - but is constantly flickering/flashing. It will do this until the "Commit changes" or "Get latest" tab has been viewed... even if the Source Control screen is not even open (let alone having focus).
The only way to stop it is to open SQL Source Control and refresh…
3 votes -
Allow Filter by object Type
It would be really great if there was an option to filter exclusions from source control by object type in addition to the Schema and Name as it is presently.
3 votes -
Override the comments italicized text when entering a comment
When committing changes, the text area shows a default message that states: "Type a comment describing your changes..."
It would be ideal if you could override this statement with one of your own in some sort of a configuration file:
Ex: "Comments are required, please reference ticket number before checking in your code..."
Speaking of a configuration file, why isn't there one???
3 votes -
Suppress credentials prompt when SSMS starts
Sometimes when I launch SSMS I see the "Source Control Credentials Required" dialog.
"""
Your source control system requires credentials.Enter the user name and password for the repository:
"""It's prompting me to update the expired credentials for one of my old development projects.
I don't want to update the credentials right now, but SQL Source Control is very persistent about it.
When I click Cancel, the dialog immediately reappears!
After clicking cancel about 10 times in a row, it finally stops asking.
Can you suppress the dialog on startup?
It would be better to ask only when it…
3 votes -
Add ability to commit read-only files.
Almost half the time when committing changes I get error message
"Error Access to the path 'C:\User\UserName\Documents\Projets\Company\Dev\Sql\Tables\dbo.myTable.sql' is denied".
Since I cannot copy this folder path, i have to manually open Explorer and navigate to the destination folder one at a time. Once I change the file to not be read only I can then checkin the file.
Possible solution 1: Make it possible to copy the folder path in the error message so that it is much faster to get to the correct folder by simply pasting the path into windows explorer..
Possible solution 2: Give a warning that…3 votes -
Show number of rows and columns when adding static data
When adding static data from a large system it would be wonderful to be able to sort on a column stating how many rows the table contains!
3 votes -
In Source Control commit changes tab
it is nice to have a search criteria for each column on the grid result in commit changes tab
3 votes -
allow copy names from result Cell by Cell
allow copy names from result Cell by Cell
Like if we want to copy only object name it should allow.3 votes -
Provide Security for the Delink Database option
Provide a mechanism, either internal to SQL Source Control or via Active Directory, to prevent the Delink Database option being selected by any user. This is to ensure that all changes are tracked via SQL Source Control.
3 votes -
Deploy to database without preserving data
am trying to deploy changes to tables from one database to another as part of development. SQL Compare insists on creating temporary tables in the target database, putting the data in them, and then trying to insert the data back into the new tables (which now have different types/names for columns).
I cannot find an option to turn off the preservation of existing data.
I want to deploy my schema changes while discarding any existing data if present. (It is called SCHEMA compare after all)I don't understand why there isn't an option to ignore data currently in target tables…
3 votes -
Items removed from the DB aren't indicated as a DB change by the SSMS GUI.
No Category for BUGS? When comparing the TFS version to live DB in SSMS, objects missing from live DB don't cause the "change" visual queue. One must select the DB/SQLSource Control/Get Latest Tab to realize there are extra items in the DB. SQL compare does not have this issue.
3 votes -
Warn when adding static data tables that have foreign keys
When adding a static data table to source control, there should be a warning if that table has a foreign key constraint on another table and give the option to include that table as static data also. As it is the error you get in SQLCI is quite hard to decipher when SQL Source Control is used in conjuction with SQLCI.
3 votes -
Fix a bug where some objects in source control are forcefully ignored due to how they're named
To enable deterministic testing using tSQLt, we replace any system calls to non-determinstic native functions like GETDATE() or GETUTCDATE() with [dbo].[getdate] user defined scalar functions (which we can then which to [test].[getdate] as part of tSQLt testing). Unfortunately it seems RG Source Control trips up on this and fails to recognise these as valid functions in the [Get Latest] tab. This means that we can't deploy using RedGate Source Control as it's usage is pretty ubiquious and with this being ignored many of our other functions fail to deploy.
3 votes -
3 votes
-
Enable merge button also on "unresolvable conflicts"
Merge conflicts cannot be resolved if both users commit and one of them pushes.
To reproduce this behavior:
1) user A performs a change on a line of a SP
2) user A commits and pushes
3) user B performs a change on the same line of the same SP
4) user B commits
5) user B tries to pull and a message says conflicts must be resolved outside SQL Source Control and it is also impossible to push (please see the attached screenshots)Only if user B performs step 4 after step 5 it is possible to see the…
3 votes -
Global Filter by Schema should exclude Schema Object with same name
This filter should exclude an object with a schema that has a matching name.
-- All Objects
Exclude where (@SCHEMA = 'tSQLt') OR (@SCHEMA = 'SQLCop')
Did not exclude this schema object definition.
-- Schema
CREATE SCHEMA [tSQLt]
AUTHORIZATION [dbo]
GO3 votes -
Hide columns for System Version Tables
We are using System Versioned Tables, and on these tables SQL server adds 2 new columns SysStartTime and SysEndTime. These columns are typically marked as hidden and we need a way to ignore comparison for these. Either by a column level filter, or an option to ignore system versioning columns
3 votes
- Don't see your idea?