588 results found
-
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
-
Option to switch order in diff panel (script for database version vs. source control version)
In the diff panel, I would prefer to see the current version in source control on the left, and the database version on the right, as that's the same existing -> new order as all my other source control tools use. How about an option to do that (that would be remembered on restart of course)
9 votes -
Must treat Static Data like source code
Our application is highly metadata driven thus we must treat our static data like source code. Specifically we need accept deleteions that are made locally, apply insertions made globally, and identify the differences. Currently Sql Source Control does NOT differentiate between rows missing from the local database because either 1) the local developer deleted them or 2) they were added by a global developer to the latest source code controlled version. In case 1, we want to drive that deleteion back into the latest source code controlled version. In case 2, we want to drive that insertion into the local…
13 votes -
BUG: Undo removes extended database properties
If I do an undo on e.g. a stored procedure. SQL Source Control removes the extended properties from the database. The extended database properties are not checked in but removed on undo. We use these properties to store some metainformation about the database itself and readding them by hand after an undo is not that funny.
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 require unlink/relink to change folder
I'm using Sourcegear Vault, but I suppose this could also apply to other SCM tools.
I'd like to see an option to change the source control folder for a database without unlinking and re-linking. This would simplify working with code that has multiple branches.
4 votes -
BUG? "Changes to commit" icon, however, there are no changes
We have some databases that get hammered overnight, tables are created, dropped so on (don’t ask, 3rd party databases = fail). Anyways, by the following day the database is back to its original state (schema wise). The databases have a "changes to commit" icon, however, when i right click and select "commit changes to source control..." it never finds anything different and i get "No objects with changes to be committed to source control".
This is repeatable and happens most mornings.
8 votes -
Repository manager
if you work with several branches, it becomes kind of hard to keep track of everything, wouldn't it helpful to have a Source Control manager or something which shows all your branches and the databases connected to them.. then you can more easily make upgrade scripts between several branches if needed.
6 votes -
on the conflict resolution screen, easier way to page down through lots of conflicts and 'take mine'
would be really nice on the conflict screen if you didn't have to click up on the row then move mouse down to option button way at bottom, 185 TIMES! If you could just select a range and say 'take mine' or page down with arrow key and hit an F key F1 mine, F2 Theirs...
7 votes -
Save my "Get Latest" choices across SSMS sessions
When I see a list of objects that require my attention via the "Get Latest" tab, I make those choices, which can eventuate in "nothing to do" and carry on working. I don't want to have to re-state those choices each time I start SSMS. Please provide a "Save Choices" facility to support this.
4 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.
-
Option to ignore GRANT differences
Working on the Company domain XX\ but Production is on RackSpace IAD\ means that every permission for domain users provokes a DIFF. I'd like the option to "ignore GRANT differences" for a target Instance. It should be OFF by default.
32 votes -
Notification that you are out of date as other users have committed changes
If other users have committed changes, it would be useful to see these so you know you need to get latest. This could be implemented as a different colored blob on objects so you know that they aren't up to date with the copy in source control
38 votes -
Detecting dependencies on object changes
Hi.
Does SQL Source Control detects and informs that a change in an object, for example, a column in a table changed from INT to BIT, will cause a break in other parts of the system like a stored procedure where that table is used?
If yes, how do I do that? If not, I would like to suggest this as a feature.
Thanks.
Jose3 votesPlease see SQL Prompt 5 at: http://www.red-gate.com/MessageBoard/viewtopic.php?t=11980
-
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 -
Track server-level security (logins, etc.)
Would like to be able to track the server-level security in source control. Logins, Server Roles, etc.
10 votes -
Provide ability to delete/drop objects from TFS / DB
If from Get Latest / Commit changes it is determined that an object shouldn't exist, currently there is no way to drop the object from the db, or delete it from TFS, via the SQL Source Control UI.
3 votesI don’t understand… If someone else committed a drop of an object, then once you click the “Get Latest” button on the “Get Latest” tab, then it will drop if from the db.
-
Have option to Pause polling of database especially if user wants to use Sql Profiler.
If user wants to run sql profiler, and doesn't want all of this background database activity there should be an option in Red Gate to pause the source control polling it is constanly performing on the linked database.
6 votesWe currently don’t have an option to pause polling in the tool, but you can confiugre an XML file. Please contact support@red-gate.com for details. This file would need to be set for each user.
You could also add a “Column Filter” in SQL Profiler’s Trace Properties’ Events Selection where “Application Name” is “Not like” “Red Gate%.” That should filter out the polling in your trace.
I hope this helps!
-
Add % Progress indicator to "Calculating Changes" & "Determining Latest Version"
When dealing with big Databases (100's of tables, views, sp's etc) "Determining Latest Version" and "Calulating Changes" can take ages, you cant navigate away to another database because the Source Tab restarts on the new database. If you cant speed this up, a progress indicator would be helpful when working on multiple databases and multi-tasking.
18 votes -
Database Diagrams
Support to check-in database diagrams
156 votes
- Don't see your idea?