53 results found
-
ignore constraint table default
Separate edit filter rule to ignore constraint names that define a default value for a column
6 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 -
1 vote
-
Set default options for comparison
Allow use to set default comparison options e.g. <AddDatabaseUseStatement> rather than have to do it for every individual database linked.
5 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 -
Allow users to change the Transaction Isolation Level. Serializable causes problems with linked servers.
Ever since updating to 3.6.0.3, the default Transaction Isolation Level in deployment scripts is Serializable. If a stored procedure has a reference to a linked database it will fail. I have to manually edit every script now and change it to Read Committed...
4 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 -
Directory and File Locations
Allow the ability to control the location of ALL files/data (permanent and temporary and logging, etc) associated with SSC. This should be asked during setup, but should also be user configurable after install.
1 vote -
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 -
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 -
Simplify datalink source code repository migration
We recently migrated our svn repo to HTTPS and part of that process was for our devs to update their SQL Source Control datalinks.
We ran into 4 issues:
1) When opening SSMS for the first time, we were inundated by SQL Source Control to update our credentials.
2) After hitting cancel 10 times, we were able to get to the Setup tab. Where we thought we could just edit the existing link, but instead we had to Unlink the database first.
3) After unlinking, all the options on the Setup tab disappeared requiring a restart of SSMS. I can…1 vote -
initial checkout failure not cought
I was checking out a database that contained changes. (new machine, database restored from backup)
The initial checkout from SVN failed because of a network issue. However the UI did not report that failure and instead proceeded to compare my current database to the local broken working copy.
It seems that the code executing the checkout is wrapped in an exception eating try catch block.
1 vote -
Migrated to new SVN server, timeout on existing linked databases is way too long
We moved our SVN repositories to a new server and the old server is already gone. I then moved ahead and tried to unlink my existing databases so I can link them to new server address (svn relocate would be another option)... Problem is that sql source control is now trying to connect to the old server and the unlink dialog is just sitting there for minutes, and I'm getting "Visual Studio is busy...." messages
1 vote -
I just want to add, query by query, to track changes. When i commit a query, the whole damn DB of queries (1000+) loads. Too cumbersome.
New user, I just want to add a query as I develop, to track changes. I expect to 1) Add a query to source control. 2) Commit the query 3) Track changes........ Problem is, every time I commit the query, the entire DB stored procedures load into memory, slow and not working for me.
4 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.
8 votes -
SQL Source Control 3.1.0.5208 Failure to load Add-on to SQL Server 2008 R2
This is actually a defect in the product. After upgrading to 3.1.0.5208 of the SQL Source Control, the Add-On for SQL Server 2008 R2 no longer loads. I had to revert to using 3.0.13.4214
4 votes -
Copy Filters between databases, or have a standard Filter template.
I would like to be able to copy the Filters to different databases, or have a Filter template which I can save to apply to other databases. There are many objects which I do not want to be moved from Development, QA, Integration and Production. Currently, I generated the XML using a query with sys.databases and saved it to DifferenceFilters.xml which is a pain.
10 votes -
Rife with Out of Memory Exceptions.
So, I install the tool to use with a real-world database of 1GB. And all I get are Out-of-Memory exceptions when trying to add data. Or even just run the tool. This is one of the worst software experiences that I've ever had!
Did I just get a buggy version? 3.0.13.4214
12 votes -
UI defefect after unlinking SQL DB from VCS
DB was linked to SVN repository.
I needed to move its location (apparently not supported).
So I unlinked, planning to re-link in new location, disregarding history.
Once unlinked, the source control tab UI was messed up.
Close the tab, re-open, still messed up.
Disconnect the DB, reconnect, show the source control tab, still messed up.
Close SQL Management studio, restart, show DB, show source control tab, then finally it was OK again.Messed up = I could not see the any of the text on the setup tab that normally says "not linked... Link DB to source control..."
In its…1 vote -
installed toolbelt this morning, uninstalled this evening due to SSMS UI impact...
I am completely put off by Redgate taking over so much SSMS UI. I was very attracted to some of the tools, but can't work like this. Tried to find way to disable/hide them, but appears uninstall is only way.
I want minimal UI intrusion until such time as I decide I like/want more UI intrusion. We need a way to dial it back to point where all redgate stuff optionally sits under single top menu and/or context menu.
I reckon in meantime I will install tools in a throwaway VM so I can see how they work without impeding…
6 votes
- Don't see your idea?