588 results found
-
Track changes as Git does / Support Git reset --soft
It would be really nice if SQL Source Control allowed commit undo like git reset --soft or tracked the filesystem as Git does instead of tracking commits.
Scenario that highlights this unexpected behavior:
- perform some changes on the DB
- commit changes
- perform a git reset --soft from command line (undoing the commit while keeping changes on the DB and file system is not possible from the SQL Source Control UI)
- if further changes are performed from the UI it is possible to commit current changes (old + further changes), but if SQL scripts are changed directly,…2 votes -
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.
2 votes -
migration scripts
When re-linking databases to source control, there is a warning message about loosing all uncommitted migration scripts, with only a OK/Cancel option. It's seems there should be an option for 'take me to the commit page' so that I can commit those scripts, then re-link.
2 votes -
Offer an option to right-click on a SQL server instance and link all databases to Source Control
Instead of having to address each database separately to link to SOC, why not have an option on the SQL Server instance to right-click and "Link All" databases in one fell swoop.
We plan to implement SQL Source Control and hundreds of databases need to be linked to SOC. We have been directed to some Powershell options which are supposed to link all databases automatically but that option is not working at our installation2 votes -
Git worktree support
I would like to see support for the git worktree feature. We often need to work on multiple branches at the same time, and this would help.
I see someone else has also asked about this as a feature on your forums. (https://forum.red-gate.com/discussion/86826/is-it-possible-to-support-git-worktree-feature-for-sql-source-control)
2 votes -
SSH Passphrase
I am not able to push changes to my repo using SSH because I am unable to enter my passphrase. I have to push/pull using Git Bash.
2 votes -
Add schema name to the commit screen
The tool assumes everything is in the default dbo schema. We have numerous schemas so its difficult to selectively check things in. Please prefix the object name with the schema
2 votes -
Add a configuration so that we stop seeing dependencies popup if not needed
We can configure SQL Source Control for setting the check box unchecked by default for dependencies popup. This should be extended one step further so we can eliminate that popup completely and reduce the number of clicks and save time.
2 votes -
Excluded objects should display an icon in the Object Browser.
I have had to exclude some objects from my SQL Source Control project and I see that it says that in the Commit tab, but they really should be highlighted with an icon in the Object Explorer.
2 votes -
Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error
Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error / warning on a view that uses that column.
2 votesSQL Prompt 5 (expected in Dec 2010 or Jan 2011) will have a feature to find invalid objects. You can get information about current early access releases at http://www.red-gate.com/messageboard/viewforum.php?f=127.
-
Make the SVN URL case insensitive
It would be easier if the SVN URL that I entered was case insensitive.
1 voteIn a future version, we hope to have the ability to browse a repository so that it doesn’t have to be manually entered. This topic is listed at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/539431-browse-to-a-svn-repository-instead-of-manually-typ.
-
Support Symmetric keys
BUG:Inital commit, Symmetric key is not added to TFS. atleast show the user that these list of items he has to add them himself
1 voteUnfortunately, we currently can’t source control asymmetric keys, symmetric keys, or certificates.
-
The ability to generate a list of objects to commit in Commit tab as well as in 'Get latest' tab.
If the list of objects to commit run over a page to several pages, it can be difficult to confirm exactly what I'm committing. I like the ability to generate a report list to show all objects as well as selected objects in the Commit tab. It would be nice to have same ability for 'Get latest' objects as well.
1 voteYou can see all the changes and generate reports using SQL Compare Pro – www.redgate.com/sqlcompare. This won’t show you what is selected though.
-
Make the SVN version more prominent
make the SVN version more prominent so (as SVN continues to evolve) I can insure consistency in SVN tools between Sql Source Control, VisualSVN, TortoiseSVN, and the Collabnet SVN Command-line client.
1 vote -
Bug? Function type detection seems unreliable
I'm having problems retrieving a recursive table-valued function from SVN so I tried to do it manually in stages which didn't work because SQL Source Control kept attempting to drop the function and then recreate it.
The steps I followed were:
1. Refresh the get latest tab and copy the function from the differences window.
2. Paste that SQL script into SSMS
3. Remove the part of the function that does the recursion (the second half of a UNION so the return type is still the same)
4. Execute the script to create the object
5. Get latest from SQL…1 vote -
Bug: commit changes showing no changes
I've just had a stored procedure that I haven't modified come up as having changes to commit. The Previous and Next buttons are disabled as though there are no differences and I can't see any differences. Yet it repeatedly comes up as an object with changes. Huh?
1 vote -
When unselecting a specfic item allow for unselect of dependent items
If I unselected an assembly (since it is 32bit and I am x64) allow me a way to unselect all dependent objects easily. If I don't select an item I have a prompt to select dependecies but not the reverse.
1 vote -
Users are not created when checking out for the first time
I've checked in a database with users, roles, tables, stored procs etc.
I've then created a new database, linked it with the repo, tried to get latest and it throws an error. The script tries to create the roles and assign users to the roles but it never creates the users. Looking through the repo, the scripts to create the users exist, but source control isn't trying to create them.
1 vote -
keep databases in sync
We are working with several customer databases on a same version of our program. Is their a possibility to keep them in sync based on 1 source control folder?
1 vote -
AutoCheck selected version objects in SQL Compare
When I look at my history, I can view all the objects in a specific version but when I click on "update to this version with SQL Compare" it get back ALL my un-synced objects.
If your systems are well synced this isn't a big deal but I have hundreds of objects that still requiring syncing so I have to search for each object and check it before I can commit.
It would be GREAT if the DB objects in a selected version were AutoChecked in SQL Compare.
It would make migrating on systems that are less than perfect much…
1 vote
- Don't see your idea?