588 results found
-
5 votes
-
fingerprint reader login
I would like to login on any SQL Source Control system using the fingerprint reader.
6 votes -
Pay attention to case changes in static data tables even if case insensitive collation used
SQL Source Control will not notice case-only changes to data if the column has a Case Insensitive collation (which is the default out-of-the-box for most SQL Server installations). This bit me when I needed to "sentence case" some "ALL CAPS" data but SQL Source Control didn't even notice until I forced the collation on these columns to be SQLLatin1GeneralCP1CS_AS, which seems unnecessary. Maybe a per-table static data option?
44 votes -
Need to disable Source Control.
Need to disable Source Control. It causes way too many errors and slowness. I only actually need to use it once every 2 weeks when we commit our work, but it runs all the time, and causes a lot of frustration.
30 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 -
Use different color for CASE ONLY changes
When I make a change and for some reason the code is reformatted and keywords are made UPPER CASE, it's almost impossible to see the actual change in the comparison view.
Please if you could just use another color if the only change in a line is about the CASE, it would be much smoother to use the tool.
Thank you for great tools!
0 votes -
Remove the Non-Standard filegroups warning
When you create an object on a file gorup other than primary you get a warning message that you are using non-standard filegroups.
This can be a little confusing since, in most cases the filegroups were crated and applied to objects for a specific purpose.
Potentially replace with a warning that the non DEFAULT filegroup being used
4 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 -
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 filter rule changes to be undone or a filter to be enabled\disabled
Changing a filter adds it to the commit tab, but the filter changes cannot be undone - which is a catch 22. If you ever want to undo filters so you can do some manipulation you should be able to undo these changes.
So, the suggestion is either
1. Add undo functionality on a filter
or
2. Add enable\disable functionality to filterI think undo should be there, because once it's in the commit changes tab there is no way out - unless you either unlink and link again or just commit or even worse, put the changes back manually
12 votes -
Allow user to disable dependant object refreshing
When getting latest SQL Source control always tries to refresh dependent objects. We have a scenario where we know we have broken objects (large database cleanup) and get latest fails because it tries to refresh those objects.
Add an option where users can skip that step. It currently generates code like below:
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Refreshing [dbo].[vSomeView]'
GO
EXEC sprefreshview N'[dbo].[v_SomeView]'
GO5 votes -
Bug: insufficient permissions when bringing database online
I have 60+ databases in my development environment, so keep all of them offline unless required.
If I bring a database online (using SSMS, right click, Tasks, Bring Online) SQL Source Control shows the error:
"Could not connect to the database. The database may be offline, or you may have insufficient permissions."
With the "complete error message" showing as...
"Cannot open database "xxx" requested by the login. The login failed. Login failed for user "xxx\xxx"."
I have access into the database, and can do anything I want with it - but the only way I can get SQL Source Control…
6 votes -
Mark renamed objects, in particular sprocs, views, udfs
When using Mercurial linking, is it possible to add a feature to allow you to mark renamed object (in particular sprocs, views, udfs), so that the change history remains?
At the moment I am forced to use "Working Directory" so that I can save the changes and tell Mercurial that the object has been renamed.
Using the Mercurial link results in an added file and a deleted file and a lost of change history.
I realise there is already a completed feature for the renaming of tables to stop data loss, which can now be done with the Migrations (…
4 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 -
some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.
We have thousands of tables (some with millions of rows) with only 90-100 static data tables.
At the moment, I have to edit the project; untick all then tick 90-100 manually which is very time consuming.
If there was some extended property or search item or project option to “link” static data tables ONLY – this would be a huge time saver.
Thanks for your response.
Regards
11 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 -
Allow include Identity option at table level instead of Database level.
In many databases there few tables with static values which are mapped with enums in the code. For such tables, Include Identity columns option is required. However, for few tables, we may not require to maintain the same primary key value in the source and target DB. Please do the needful
29 votes -
Move sp_addrolemember scripts to be in User Object instead of Roles Object
In our System we have 2-3 predefined Roles that the application uses to run against.
The Issue I am running into is when scripting the roles i don't want all the sp_addrolemember being scripted into source control as the users using the role will be different in different environments. So it will always show up as a diff if the Role is already created and assigned to a user.
I would like suggest adding those sp_addroletomember scripts be configurable to be scripted in the User object they belong to instead of in the Role Object
7 votes -
Change the icon in ssms for the tables that are linked as static data.
When you link a table as static data in Sql Source control it would be nice if the static tables were easily identifiable under the tables node in management studio.
28 votes -
Provide a way to enter bugs
Your feedback system should allow for a way for a user to input bugs that they find.
For example, allowing unselect all for existing changes.
I've never been a fan of SQL source control, and this product has made me dislike it even more.
1 vote
- Don't see your idea?