179 results found
-
How to reject changes?
Is it possibility to reject changes which has been made for object? I couldn't find such function. If there are not, there should be such possibility.
4 votesIf you haven’t commited your changes yet, then you can right-click on the object in the Object Explorer and select Other SQL Source Control Tasks > Undo. This will revert your change to your db so that you are back to the state you were in before you started making changes to the object.
If you actually want to get back to a previous version, then please vote/comment at https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/492431-get-specific-version-from-source-control-svn-upd.
-
Allow "Undo" from "Commit Changes" tab
It would make much more sense to me to be able to look at the Commit Changes tab to see what's been changed and right click on an item and choose undo if I need to revert it.
4 votesThis feature is now available as of v1.1.0.19. Please use Help > Check for Updates on the SQL Source Control tab within SSMS to make sure you have the latest version.
Thank you!
-
Clean up WorkingBases After Unlink
After unlinking a database, I end up with an abandoned workingbase folder. Frequently unlinking/relinking (to emulate an SVN SWITCH between branches) builds up a whole bunch of sizeable folders in workingbase.
4 votesSQL Source Control 3.0 is now available and it includes a fix for this issue! Working base folders are now be deleted when a database is unlinked.
For more information about the features of SQL Source Control v3, please visit:
http://www.red-gate.com/products/sql-development/sql-source-control/features -
Display History in my time instead of UTC
It appears the new History feature is using Universal Time Code instead of the local time that is used everywhere else.
4 votesThis fix is included in SQL Source Control v2.0, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
-
Failed commit clears comments
If I attempt to commit something (in this case it was an object with a dependency I didn't include in the list of objects to commit) and that commit fails, you not only refresh the list view again (I can live with that) but you clear the comments. Given the already dismally small field (way too small given how many objects I might be checking in), I have to edit these in a text editor first (you don't support tabs either in there) and paste it in...well, if I don't realize there's going to be a failure (happens often enough),…
4 votesGreat idea!
-
Where can I enter credentials for TFS access
I'm missing an option to add credentials to TFS. Is it not there?
4 votesGood news. This has been implemented in SQL Source Control 3.4.10.126, which will download if you check for updates.
By default it will try and use your windows credentials for TFS, however if that fails you will now be prompted to enter new credentials.
Full release notes on http://documentation.red-gate.com/display/SOC3/SQL+Source+Control+3.4+release+notes
-
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.
-
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.
-
Crash with Analysis Services
When I try to open up an analysis services database (to view), SQL Source Control crashes.
3 votesThis was fixed in v0.2.1. Please upgrade to the latest version by clicking Help > Check for Updates.
-
allow start entering commit comment while sql source control "determining latest version" and so on.
3 votesThis feature is now available as of v1.1.0.19. Please use Help > Check for Updates on the SQL Source Control tab within SSMS to make sure you have the latest version.
Thank you!
-
Dedicated DB VS Shared (Centralized) DB Model
I recentrly had a brief email exchange with Stephanie from Red Gate, where I explained that we use a centralized Development database, instead of every developer having a dedicated local version of the DB against which they develop. I believe that the Centralized Dev DB model is the model used most in the field, mainly for two reasons. 1) Most companies don't want their developers to have local copies of the database for security reasons, and 2) Development DBs often hold a lot of test data which would not be practical for all of the developers to have locally.
Having…
3 votesSQL Source Control supports either model, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
v2.0 has the following enhancements for the shared model:
If you setup your database as shared, then you will see who last updated each object on the Commit tab and Undo dialog. Only objects that you last updated will be checked by default. This will prevent you from accidentally committing/undoing others changes that work on the same db.We are also addressing the problem so that you will no longer see invalid conflicts on the Commit tab.
-
Support of Continuous Integration
We evaluate SQL Source Control in an internal project and it already saves us a lot of time in our daily development work.
On top of our subversion we use a Continuous Intregration Server so it would be great if we could trigger SQL Source Control by that Server. A simple command line tool with some parameters would be sufficient to automatically sync a test database with the subversion so that afterwards a couple of SQL test scripts could be executed.
3 votes -
Overlay icons disappear in SSMS 2008 (10.0.2531.0) connected to SS2005
The overlay icons disappeared when I connected to a SQL Server 2005 database using SSMS 2008. This is the first time I've noticed this behavior.
3 votesHi. We think that this is fixed. Please let us know if you’re still experiencing issues with the icons.
-
The whole thing is dead sexy.
I'm looking forward to source control of data. It's very low impact, which are the only kinds of tools that get used when schedules get off track, which is to say, week three of any project.
3 votesThanks for your feedback! It’s great to hear! :-)
I’m closing this suggestion so you can have your votes back… -
Error when you using a table alias AS GO
I got an error when there was a stored procedure that the table had an alias as GO and it didn't let me commit any changes or get latest
3 votesIn v1.0.4, we updated our parsing and we can now handle GO as an alias in some places.
We still recommend not using GO as an alias since it is a keyword.
Please email support@red-gate.com if you experience any issues when using GO as an alias.
-
What happens on table definition changes if I change a nullable column to NOT NULL
If i make a table column which was nullable initially to a non-nullable; and then commit this change to svn. On the other computer, when i update from svn, what happens to the data? as the records in this table may have the null values in the column i just changed.
3 votes -
Allow option to link to workspace, instead of repos
By linking to a subfolder of an existing workspace and maintaining the copy there, it would be possible to allow an external program to handle the actual commit, and by that including the SQL changes into a bigger revision
3 votesYou can link to a folder by creating a custom config file and leaving the options blank. This will just script out the objects to the folder, but not actually commit them. More information can be found at http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_working_with_config_files.
-
Copy SQL statement from compare pane
When I mark an object, I get the differences at the bottom of the window. In one pane is the old and in the other the new sql code.
I would like to mark and copy this code but the copy functionality isn't available for these two panes.3 votes -
It would be nice to be able to have a one click, generate database using the latest verision
That within the SSMS the ability to generate a create database script off of the repository. I know you can do this in mgmt studio, but being able to have a full script in the repository that will build the database at that version would be sweet.
3 votes -
Allow me to add a comment when linking a db to source control
We have pre-commit hooks enabled in SVN to make sure a reference to a Jira ticket is entered and creating a fresh DB link fails with these enabled as SSC will try to add a standard comment that does not match the required format. Every action requiring an SVN log message, should prompt for one
3 votesThis feature now appears in SQL Source Control version 2.2!
For more information about the release, please see:
- Don't see your idea?