SQL Source Control
Thank you for evaluating SQL Source Control. Your feedback will impact what we do next!
-
Exclude/Include filter not working as expected, SLOW performance
we have 13000 objects in our database.
12800 of them are all in the dbo schema which contains the standard logic for our product.
The rest 200 are in the customer specific schema.
We are not interested in source controlling the standard logic, since we get it from our supplier.
We need to source control our customer specific changes. For that every change is made in another schema.
We can perfectly filter the objects out for source control with your tool.
(so they do not appear on the commit screen). However it is very very slow, that's why I suspected…1 vote -
Cannot Get Latest
Everytime I try to Get Latest I get the following....
System.Exception: Failed to update to the head revision after 10 attempts ---> System.Exception: Failed to update to the head revision after 10 attempts
at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetDatabaseFolderWorkspaces(ICancellableOperationStatus status, IScriptFolderStructure scriptFolderStructure, IReadOnlySourceControlServerCallBacks callBacks, SourceControlRevision& revision)
at #GWeb.#WXM.#Fieb()
at #GWeb.#Wheb.#tieb(Func`1 )
at #GWeb.#WXM.#8ZW(Boolean )
at #GWeb.#XXM.#yRW()
at #GWeb.#WXM.#qYM()
at #GWeb.#XXM.#iS()
at #qlhb.#0heb.#l36(String , #1heb , ICancellableOperationStatus )
at #qlhb.#K3c.#83c(String , #O9U , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#A3.#eL5b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#jzb.#Qnw()
--- End of inner exception stack trace ---
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#VAb.#xSXc()
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action ) …1 vote -
For shared development environment, replace "GET ALL" with list of historical changes made
When developing in shared enviroment, I'd love a history tab that I can review all revisions with details, and not have to have a modal window separately. I believe this should be integrated into the main source control tab as change history log. This could help make others aware of changes made that could affect them, yet were already committed. Thanks!
1 vote -
When opening SSMS show all databases with differences in the Object Explorer view without having to select each individual database
When opening SSMS highlight all databases with uncommitted changes in the Object Explorer view without having to select each individual database.
1 vote -
On conflict when commiting changes able to right click and open proc/table in new sql editor
When you get conflict when commiting changes it would be nice to be able to right click and open proc/table in new sql editor, do you change (merge) and continue.
14 votes -
On shared mode, Source control sync delayed issue
Shared mode is perfect for small team DEV environment, but status update delayed to sync is annoying....is there a way to config the sync frequency?
3 votes -
Why do you have to be in sysadmin-role to see who checked in changes?
Ít would be nice, if you dont have to be in sysadmin-role to see wich user has made changes. thx.
5 votes -
SQL Doc - Rename or remove server name
When generating documentation in SQL Doc it would be nice to either rename or remove the server name. If I'm generating documentation for a client, for example, I would rather they not see the SQL Server name and get confused.
6 votes -
Accomodate for people with colour blindness
One of my colleagues has colour blindness.
The distinction between a non-reviewed database (the grey circle) and a database with outstanding changes (blue / white icon) is difficult to see because of the fact that the icons are so small (the less pixels to compare, the harder it is by all accounts) and often can be far away (i.e. if there are other non-source controlled database between them on the database tree in SSMS).
It would be helpful to make a clear distinction between the icons - either make the grey icon a flat colour (i.e. remove the highlight within…
5 votes -
Add button Stop/Start Checking for modifications
Sometime I work with proxy of my customer and my DB, linked to source control, can't connect.
Please, I need a Start-Stop button to stop the connection with the source control in this situation. Thank you.4 votes -
Add contained database support in SQL 2012
Need to have better support for contained databases feature of SQL Server 2012. For example a new feature - user WITH PASSWORD is scripted as a user WITHOUT LOGIN.
3 votes -
BUG(?): Rebuilding a table via migration script doesn't add the correct authorization commands
When rebuilding a table via migration scripts, the ALTER AUTHORIZATION TO... commands are omitted on the replacement table when the migration script is created by SSC.
1 vote -
BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked
BUG: commit changes include other objects although I have specified that it should not include other objects than the ones i have checked
4 votes -
The toggle button functionality
I have version 3.2.0.27. When you have conflicts, the toggle button at the top of commit and get latest won't uncheck items that SQL Source decides to check. I have to select all the items and then click a box to uncheck, then check the ones I want. If I don't want to resolve the conflict yet, it's not ideal.
10 votes -
Provide a way to post configurations that must be implemented as TO DO items
I have a service broker application where some parts such as service routes etc must be defined per database configuration, thus certain components change per installation so it would be nice to tag such items as TO DO items, like wise once complete when comparing to latest or changes the item is not displayed as an object that has changed.
Going further it might be nice to populate table data that also configures per installation as well
perhaps use of extended properties, or a file present in source. I had taken the source code and placed a comment in it…
1 vote -
Auto link source control to repository
My use of Source Control is in its infancy, but it would appear that when you commit your changes to Source Control, an entry to your repository (for us its TFS) and the version number. From what I understand this is only used by the compare products. But why can't this link be used by Source Control to automatically link others to the same repository?
4 votes -
SQL Source Control Configuring Data Compare Options
Make it possible for us to configure how SQL Source Control does its data compare. There are some great settings that work within SQL Data Compare 10 that allow a user to configure how data in each table is compared between data sources. Currently the main feature I want is to allow the selection of table columns to actually compare (i.e. one column is an identity field which isn't always the same).
7 votes -
object_schema_name
Bug: the function object_schema_name is not recognized as a valid system function, and is wrapped in [] when committed to subversion backend. Scripts defining tables or stored procedures that use this function have to be edited to remove the [] before they can be successfully run. Please fix this, this is a function we put into almost every table as part of the default value in a "created by" field.
2 votes -
Use windows username instead of disaply name for linking to TFS 2012
I am unable to link databases to TFS 2012 due to our parent company enforcing a Active Directory display name of "LastName, FirstName" which TFS claims is invalid due to the comma.
It is a known issue with TFS (http://connect.microsoft.com/VisualStudio/feedback/details/768112/tfs-2012-build-failing-with-tf10158-user-name-contains-unsupported-characters)
The workaround listed on Microsoft Connect is to use "domain\username" instead of display name when sending commands to TFS. Unfortunately, SQL Source Control doesn't expose a way to do this currently.
5 votes -
Step 4 takes a very long time since I upgraded to 3.1.0.5208.
Seems that since the release of SQL Source Control 3.1.0.5208 step 4 has been taking a very long time. I don't know if this is just my set up or is happening for everyone. Also, if I try to do a dedicated database development then step 4 never finishes.
26 votes
- Don't see your idea?