587 results found
-
Ability to disable transactions when updating DB
Ability to disable transactions when updating DB with latest changes.
3 votes -
7 votes
-
Relocate
Be able to apply the SVN Relocate command. I often switch between our SVN server while on the LAN, but then when on the road I connect "relocate" to the SVN server using external IP address of the server using the SVN relocate command.
1 vote -
Better use of keyboard commands.
It would be great to be able to use the keyboard to do fire off commands more quickly (especially when doing the same task on many objects).
A good example is that I granted a bunch of permissions to a user and then needed to accept my own changes which requires, using the mouse to select the item and then use the mouse again to select the radio button for "use mine". If there was a key combination to select "use mine" then I could just down arrow and then hit this particular key combination.
4 votesAnother trick is to use your mouse to select all the rows and then Keep Mine/Take Theirs will apply to all the highlighted rows.
I hope this helps!
-
I want to look at SSC and see a det summary of all linked server/database instances and version
It would idea if you could see all linked server/databases within SQLSource Control and the version that they are running or at least the last version that they sync'd with
3 votes -
memory usage
Is it possible to tell the tool to release memory. I notice it consumes an enormous amount which I can understand, but would like to release it once I'm finished using the tool. I understand it will have to consume the memory again next time it compares my db to the repository.
7 votes -
Improve performance over remote connections
We have a team that works remotely so no local network access to source control, only access over the internet. Sometimes I cannot get latest or commit anything because most of the time the source window is stuck on "Determining latest version". I've let it run for a few hours with no luck. It is a relatively large database with around 2000 objects, 1000 stored procedures which have a total size of 4.3MB text.
A SQL Compare snapshot of this database is 23MB or 6.5MB compressed.
What about having an intermediate service which runs on same local network as source…
24 votes -
Warn when Get Latest cause data loss
If a table or column is dropped in svn, e.g. due to a merge from one branch to another, then Get Latest will happily do this without notice. Any data loss caused by Get Latest should at the very least cause a warning.
8 votes -
Detect disabled indexes
I disable an index on an indexed view and source control doesn't detect the difference, but if I do script object as alter I see the disable line added.
6 votes -
Do NOT show SQL Source Control tab when starting SSMS
SQL Source Control tab should NOT be the DEFAULT on SSMS startup, Object Explorer Details should be the tab selected.
6 votesIf you close the SQL Source Control tab, then it will NOT show up the next time you start SSMS.
-
Allow "Get Latest" in shared model
We occasionally restore a copy of production db over our development db. With SCC in place I imagine it will work like this:
1) Everyone commits dev changes that they care to keep
2) perform restore
3) One person relinks SSC in dedicated mode and uses "get latest" to pull down latest schema to the newly restored dev db.
4) everyone can resume working in shared model.
To cut out the relink in step 3, it would be nice to be able to use the "Get Latest" tab in shared model for occasions like this
34 votes -
commit changes: Enhance mousewheel in Text Comparison
In the lower panel where I compare the text of different Versions I expect more functionality, when I use the mousewheel, e.g.:
Ctrl+Wheel: Change Text Size
Shift+Wheel: Scroll Horizontally
Ctrl+Shift+Wheel: ??4 votes -
Include Linked Servers as a versioned object
We use Linked-Servers to connect to Oracle databases. These objects can be added by a developer and then need to be versioned like any other SQL object.
7 votes -
Save position of comment divider
Thank you for making the comment field bigger. Now, if you could just ensure the component remembers the position of the divider between the comment/header area and the list view below it, that'd be even better. Right now, I have to keep resizing it every time I launch the SMS. Annoying but obviously it can be worked around.
3 votes -
DB level Extended Properties
We have extended properties setup on the database level that currently can't be checked into source control. It would be nice to have that as an option to look at DB level extended properties.
4 votes -
Undo data changes
I can undo any DDL operation but I don't have the option to undo a data change in a source controlled table. I think data changes should also be in the list of changes I can undo.
200 votes
Kendra
responded
While SQL Source Control does not currently provide a simple way to right click and ‘Undo’ static data changes on the ‘Commit’ screen as suggested, there is a workaround which may help some users.
If you wish to revert the static data in the table to a previous version which you have committed, you can do this by viewing the history of commits for the object in SQL Source Control, and then launching SQL Data Compare to update the database.
Please note that this workaround requires a license for Data Compare. More detail on how to do this are here: https://documentation.red-gate.com/soc/common-tasks/update-to-a-revision-from-source-control
-
Allow Setup at the INSTANCE Level
Please consider allowing, in a single action, the addition of ALL (or a selection of) databases in a server to the same base VSS location. This would require you to create new projects under the root for each DB and simply auto-commit the changes. Currently, Initial setup on servers with dozens of DBs is quite daunting.
4 votes -
Add commands
Being able to add our own commands that appear when you right click an object in SSMS.
9 votes -
Automatically Check for Changes and check those changes in periodically.
If I could have the product walk a bunch of databases on a server (like a dev server) at 4 PM every day and check in any changes either completely automatically or with a single click for all dbs that would be sweet.
Another use case for this is when I have to revoke a users rights to a bunch (20 or more) databases on a server with a script but then have to check in the change on each db one at a time.
6 votes -
Check in sub-object changes
When working in an Agile environment I will have changes that need to be checked in for the current sprint while still modeling for the next sprint. I would appreciate a way to click on the "arrow" in the source control compare window to commit, for example, 1 out of 3 column changes in the Person table or a line change in stored procedure that coincides with 1 column change and leaving the other lines alone for the next sprint.
6 votes
- Don't see your idea?