179 results found
-
Support for SQL Server 2019 Inline function syntax
SQL server 2019 new syntax, for instance for inline functions, is not supported by Redgate Source Control. Could you please add that support? There is another user with the same problem as described here.
Thanks in advance.
Best,
Jose.6 votesSupport for the inline function syntax has been released in SQL Compare v 15.2.5. You can get the latest version at https://www.red-gate.com/products/sql-compare.
-
Stand-alone app
I'd suggest rebuilding Red Gate SQL Source Control into a stand-alone application (similar to SQL Compare & SQL Data Compare), instead of a plug-in to SSMS.
My SSMS has gotten awfully slow since installing SQL Source Control, even after unchecking the Changed Object & Static Data control options, AND setting EnableObjectLocking to FALSE under the hood.Consider that I'm working all day in SSMS, but I only need SQL Source Control maximum once or twice a day, when committing changes to Git.
Kind regards,
Christof11 votesThe next version of SQL Source Control will be merged into Flyway. Flyway Desktop is a standalone application and provides versioning for over 20 RDBMS. You can learn more about transitioning from SQL Source Control to Flyway at https://documentation.red-gate.com/fd/sql-source-control-164167857.html.
-
SQL Source Control Git Hook Support
Sql Source Control can be made better by adding support for git hooks in the Sql Management Studio Source Control interface.
Example: Create a pre-commit hook to stop outgoing commits if tsqlt tests do not pass.
Expected outcome: A commit that fails the pre-commit hook should not be created. This is the behavior of the git command line.
Current outcome: Sql Source Control does not respect the git hook and bypasses it allowing the commit to be made.
37 votesSQL Source Control 7 has now been released. In this version, SQL Source Control now uses the Git command line for all its Git interactions, which means it will support any Git hooks that have been configured.
You will need to ensure that you have Git.exe available in your system path – the easiest way to do this if you don’t already have Git installed is to download Git for windows (https://git-scm.com/download/win)
-
Make SQL Source Control Options easier to access
In order to access some options, such as enabling SQL Source Control in multiple instances of SSMS, you have to access a section of the setup tab that you can only get to after you have a database linked to a version control. This kind of thing should be available without having to go through all of that.
As an example of where this comes into play, I open a local DB that I have no intention of attaching to SC and do some work. I then open another DB in another SSMS instance that I do want to deal…
4 votesThe latest frequent update release of SQL Source Control (5.8.0) implements the Global Options as a dialog. You can access it by clicking “Options” in the top right corner. Thanks for your feedback.
-
ReadyRoll integration with Source Control
ReadyRoll looks great but one of it's downsides is that you have to use Visual Studio. If mostly work gets done using SSMS, then switching to Visual Studio is not a great experience.
Both ReadyRoll and SQL Source Control use the same comparison engines, they both output objects as files on disk and support migrations.
To satisfy both worlds (making great experience when using Source Control on SSMS) and have a proper way to automatically update databases from source control files using migrations (like ReadyRoll does), SQL Source control should integrate with ReadyRoll - after each commit, a migration script…
33 votesIn the past year we have introduced a way to do what you have suggested her, which is a hybrid method of using SQL Source Control with SQL Change Automation (which is ReadyRoll under the new brand).
In designing the integration, we found that some users wanted each developer to generate migrations as part of their workflow, while others preferred for this to be done in batches, perhaps by a DBA, when preparing a deployment.
More information on the hybrid workflow is here: https://www.red-gate.com/hub/product-learning/sql-toolbelt/a-hybrid-approach-to-database-devops
Thanks very much for this suggestion and we would love further feedback on whether the hybrid workflow meets your needs.
-
SQL Source Control Missing in SSMS in SQL2016
When I installed Toolbelt I has SQL 2014 now I have added SSMS2016 and its only Prompt and SQL Test that is visible. I have tried running a reinstall but it tells me that the products are already installed - what's going on!
4 votesThe latest version of SQL Source Control (5.7 / 5.8) in the Toolbelt should support both SSMS 2016 and SSMS 17. If you have problems, please don’t hesitate to contact support directly.
-
Support GIT hosted under TFS
We use GIT hosted under TFS in order to use Windows authentication to protect the GIT repositories.
SQL Source control does support a local copy of the GIT repository but remote Push and Pull fail in SQL Source Contrtol 5 because it cannot handle the login dialog needed to get to GIT
240 votesSQL Source Control 7 has now been released. In this version, SQL Source Control now uses the Git command line for all its Git interactions, which means it will support any Git authentication method that the command line supports. This includes TFS Git.
You will need to ensure that you have Git.exe available in your system path – the easiest way to do this if you don’t already have Git installed is to download Git for windows (https://git-scm.com/download/win)
-
High DPI screen scaling doesn't work well with SSMS 2016 RC3
High DPI screen scaling doesn't work well with SSMS 2016 RC3.
The source control screen doesn't fill the entire work area, but just takes up a small rectangle in the top left (approximately 50% x 50% of the work area).
This occurs on a 3840x2160 pixel screen, SSMS version 13.0.14000.36, red gate source control version4.4.0.1714 standard18 votesThis problem should be resolved in version 5.8.3, because we’ve changed the UI technology used on the setup, migrations, and object locking tabs.
-
When we do SQL Compare from source control to source control, the URL of our repository appears at the end of the script - can it be removed
When we use SQL Compare from source control to source control, the URL of our source code control repository appears at the end of the script. This is causing security issues for us. There should be a non-manual way to remove this link.
1 voteI am delighted to let you know that this is now released! With Migrations in SQL Source Control 5, the URL to your repository no longer appears.
If you don’t have the tool installed, you can download it from http://www.red-gate.com/products/sql-development/sql-source-control/.
If you already have SQL Source Control you can get the new version via Check for updates in the Help menu of SQL Source Control inside SSMS.
You can see other Migrations examples and tutorials here: https://documentation.red-gate.com/display/SOC5/Migration+script+examples
Thank you for sticking with us while we worked on this, and please keep the feedback coming!
-
Commit Dialog: Highlight selected object
The selected object in the list of items to be committed used to be highlighted.
I'm on v 4.1.13.94, using the SVN connection. selected item is no longer highlighted.
Maybe it's me? is there a config option I accidentally set?
1 voteThe release later today should change this to a lovely shade of light blue, and be more visible.
-
Add SSH key support for push/pull to remote Git repository.
When using the 'Push to remote Git repository' feature in SC 4.1.8.41, add functional support for remote Git repositories that use SSH keys for authentication.
89 votesSQL Source Control 7 has now been released. In this version, SQL Source Control now uses the Git command line for all its Git interactions, which means it will support any Git authentication method that the command line supports. This includes SSH support. You’ll need to make sure you have your SSH key correctly configured for the Git command line to use.
You will need to ensure that you have Git.exe available in your system path – the easiest way to do this if you don’t already have Git installed is to download Git for windows (https://git-scm.com/download/win)
-
Stop treating Git like a red-headed step child.
GIT seems to always get the short end of the stick. Can't do Object Locking, can't do Migrations, can't do Get Latest, can't View History.
Please stop treating GIT like the middle child in the Brady Bunch. GIT is totally Marsha, not Jan.
13 votesI love your request to much, I’m going to hate to close it as finished soon….
Git is a first-class citizen in SQL Source Control 4.1, which is scheduled to go out within a couple of weeks. You can get it right now if you sign up to the ‘Frequent Updates Channel’ (instructions here: https://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates).
We’ve added Commit, History, Push and Pull (Pull+Apply changes = Get Latest) for Git.
Object locking can be used with Git, but it’s a database-level thing, so is really only useful if you have multiple people sharing a database – a relatively uncommon set-up for Git users.
The latest version of Migrations, in SQL Source Control 5, now supports all version control systems, including Git.
Since that covers every item on your list, I’ll mark this as completed – but thanks for making us giggle too.
Mike Upton
Technical Lead | SQL Source Control -
Require lesser SQL Server permissions than dbo to use
The permission of dbo required to use SQL Source control is not good and indeed a lot of dba's do not like the idea of having to grant dbo permission for users who wish to use the source control. In some companies it would not be possible to grant dbo permission.
Could SQL Source Control be changed to not require dbo but perhaps something lesser. Indeed give the option to not writes extended properties at the database level.14 votesI’m pleased to say that the latest version of the migrations feature no longer requires extended properties on your database.
This means that as of version 5.1.1 of SQL Source Control, Alter Database/dbo permissions are no longer required.
Mike Upton
Technical Lead | SQL Source Control -
Show server name in main window
My databases have the same name on the production server, the dev server and my local machine.
Sadly Source Control shows me only the database name in the upper right conor of its main window. And because there is neither a status bar nor the server name in the tab name, I'm often unsure which database exactly it compares at the moment.
PS: I know, it is the one with the one with the light-gray-on-white-background in the object explorer, if I scoll up to the database level, but the scrolling is annoying and I have to look twice to see…
3 votesThis should be available in our next frequent channel update (on/after August 19).
-
Add 'git push' and other DVCS equivalents
In the SQL Source Control GUI add a button or checkbox to allow pushing changes to the remote repository. This saves having to go to the command-line or another GUI to push our changes up to the remote repository.
21 votesGood news! SQL Source Control 4.1 now lets you push your changes in Git.
After you commit changes (which you can now do inside the tool, rather than just saving and committing externally), you have the option to push to the remote repository. Similarly, when you get latest, you can pull changes.
We think we’ve got the major actions covered now and that if you’re doing anything more advanced, you’d probably prefer to do it in your regular external git client.
But please tell us in separate UserVoice requests if there are other actions you would like surfaced in SSMS via SQL Source Control!
-
When I check commit changes I used to get the TFS changeset number which was really useful. Now I don't seem to. Has something changed?
Where has TFS changeset notification gone?
1 voteThis is now fixed in the latest frequent update release.
-
To be able to configure the default behavior of the 'Include Dependencies' check box
When committing changes to source control, the 'Include Dependencies' check box is set to true. Can this default behavior be changed to false?
OR
Can the user have the option to set the default behavior?3 votesThe latest frequent-update version of SQL Source Control (4.0.6.179) allows you to default the checkbox behaviour to off. To do this, you’ll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you’ll find in localappdata\Red Gate\SQL Source Control 4 and add a tag called IncludeDependenciesCheckbox, like this:
False
If the value is false, then the checkbox will be un-set by default. -
It would be helpful if Source Control showed which branch is checked out currently.
Before every commit I have to check in git if the selected branch is the appropriate. It's important and it would be easier, if SQL Source Control showed it.
67 votesAs of SQL Source Control version 5.6.1, the Git branch name is now displayed just above the commit/apply changes buttons.
-
Allow users to suppress the commit dependencies warning screen and automatically do not commit the dependencies.
We don't have our schemas in source control so every time we commit code the dependencies screen comes up warning us that the schemas are not in source control. Every time we commit we have to uncheck the box and hit continue. You should allow users to suppress the commit dependencies warning screen and automatically do not commit the dependencies.
2 votesThe latest frequent-update version of SQL Source Control (4.0.6.179) allows you to default the checkbox behaviour to off. To do this, you’ll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you’ll find in localappdata\Red Gate\SQL Source Control 4 and add a tag called IncludeDependenciesCheckbox, like this:
False
If the value is false, then the checkbox will be un-set by default. -
Bug: Changes detected after commit
There are changes detected to a table in the commit screen, but the details show no changes - even after committing this phantom change, the commit screen still shows that table having changes pending. v3.5.6.338 standard. A few things to note about the table that might help to resolve: The table is a partitioned table, with a Geography data type in it, and also has a ColumnStore index.
10 votesClosing this as it looks like SQL Compare now supports ColumnStore indexes
- Don't see your idea?