588 results found
-
Provide a way to post configurations that must be implemented as TO DO items
I have a service broker application where some parts such as service routes etc must be defined per database configuration, thus certain components change per installation so it would be nice to tag such items as TO DO items, like wise once complete when comparing to latest or changes the item is not displayed as an object that has changed.
Going further it might be nice to populate table data that also configures per installation as well
perhaps use of extended properties, or a file present in source. I had taken the source code and placed a comment in it…
1 vote -
BUG(?): Rebuilding a table via migration script doesn't add the correct authorization commands
When rebuilding a table via migration scripts, the ALTER AUTHORIZATION TO... commands are omitted on the replacement table when the migration script is created by SSC.
1 vote -
Cannot Get Latest
Everytime I try to Get Latest I get the following....
System.Exception: Failed to update to the head revision after 10 attempts ---> System.Exception: Failed to update to the head revision after 10 attempts
at RedGate.SQLSourceControl.Engine.LinkedDatabase.GetDatabaseFolderWorkspaces(ICancellableOperationStatus status, IScriptFolderStructure scriptFolderStructure, IReadOnlySourceControlServerCallBacks callBacks, SourceControlRevision& revision)
at #GWeb.#WXM.#Fieb()
at #GWeb.#Wheb.#tieb(Func1 )
…
at #GWeb.#WXM.#8ZW(Boolean )
at #GWeb.#XXM.#yRW()
at #GWeb.#WXM.#qYM()
at #GWeb.#XXM.#iS()
at #qlhb.#0heb.#l36(String , #1heb , ICancellableOperationStatus )
at #qlhb.#K3c.#83c(String , #O9U , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#A3.#eL5b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#jzb.#Qnw()
--- End of inner exception stack trace ---
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#VAb.#xSXc()
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action1 vote -
get latest from source control - dependencies
After you click the "Get Latest" button, while the "Determining schema changes" step is processing, there is a dialog that will sometimes pop up that says "Get latest from source control - dependencies". The "affected objects" list does not include the schema name for these objects. For databases that make heavy use of schema names, the schema name is critical to display here.
1 vote -
Buggy feature with Mercurial, maybe other source control systems too.
When I update to a node in a branch that is not the head of the branch, for instance to rollback my database to a previous tag. The moment I hit the get latest tab in SQL Source Control, it automatically updates to the head of my branch, making it impossible to revert to a previous version.
1 vote -
Clone db from server to other server
Clone db from server a tomserver b without genarating a bk file
Direct bk restor without generating file
This alow to save time and space1 vote -
When tables with linked data are renamed, the new tables do not have linked data
Linked data settings should be remembered when a table is renamed
1 vote -
1 vote
-
Allow migration script to be added even if I don't want to check in all dependant objects
When I try to create a migration script on a (not yet checked in) object, and that object has a dependency on another object, then SQL Source Control requires that I add the dependent objects to the migration script and the subsequent checkin. SQL Source control is correct that there's a SQL-level dependency between the two objects, but as a developer, I can tell that it's safe to check in one without the other.
As a workaround, if I checkin the change first without the migration script, SQL Source Control suggests that I also checkin the dependent objects, but doesn't …
1 vote -
scripting changes
A while ago I had discussed with Redgate about how to allow sql source control to create scripts for releases to deploy db changes.
This mostly works, except when there are changes that require more logic to properly handle existing data when certain db object changes are made.For instance, adding a new column to a table (that has data in it) that is required, but does not have a default.
The current way of handling this is to create a custom script for that change at the time of check in. The problem with this is that it requires…
1 vote -
Toast notification displays on wrong monitor
The "toast" / desktop alert popups by the system tray always seem to show on my primary monitor (where my start menu is). However I often have the app running on my secondary monitor and it would make more sense if the popups displayed on the same monitor as the window where the action triggered the popup
1 vote -
Prevent false commit
If I make a change to a proc in management studio editor, then execute the alter. That change is not reflected in object explorer until i do a refresh of object explorer. After the commit SQL source control still show a change and this can result in your change reverting if you press commit again. Therefore sql source control should do a refresh of the committed object in object explorer after every commit.
1 vote -
"SQL user without login" should be supported without Warning
SQL user without login is not correctly detected by SQL Source Control
The Warning displayed is confusing1 vote -
Migrated to new SVN server, timeout on existing linked databases is way too long
We moved our SVN repositories to a new server and the old server is already gone. I then moved ahead and tried to unlink my existing databases so I can link them to new server address (svn relocate would be another option)... Problem is that sql source control is now trying to connect to the old server and the unlink dialog is just sitting there for minutes, and I'm getting "Visual Studio is busy...." messages
1 vote -
initial checkout failure not cought
I was checking out a database that contained changes. (new machine, database restored from backup)
The initial checkout from SVN failed because of a network issue. However the UI did not report that failure and instead proceeded to compare my current database to the local broken working copy.
It seems that the code executing the checkout is wrapped in an exception eating try catch block.
1 vote -
Simplify datalink source code repository migration
We recently migrated our svn repo to HTTPS and part of that process was for our devs to update their SQL Source Control datalinks.
We ran into 4 issues:
1) When opening SSMS for the first time, we were inundated by SQL Source Control to update our credentials.
2) After hitting cancel 10 times, we were able to get to the Setup tab. Where we thought we could just edit the existing link, but instead we had to Unlink the database first.
3) After unlinking, all the options on the Setup tab disappeared requiring a restart of SSMS. I can…1 vote -
Automatic source control migration scripts facilitation/generation/recording.
When using development tools to modify a schema, you can end up having applied a number of changes which cannot be applied without data loss using schema differencing and which need to be included in a migration script.
It would be helpful if there was some form of SQL trace which could monitor schema changes actually applied, and be used to generate a composite migration script.
If I use Enterprise manager, or Red Gate to refactor the schema, it is up to me to remember to save the generated SQL and any other SQL I might write along the way…
1 vote -
On the "Get Latest" page, provide a way to globally un-check all objects
Can you please provide a way to "Uncheck" the entire list of objects on the "Get Latest" tab. I have 100+ objects ( Team of 6 Devs ) to get latest and 3 or 4 objects have issues, so I have to manually uncheck each of the 100 checkboxes and then check just the ones I think are ok to check in
1 vote -
Disregard pending changes WITHOUT revert
It can and does happen.. you end up with objects that you know are in production but for whatever reason never got committed and put into a migration script. Or, you just aren't interested in ever putting a certain change live.. maybe they are dev only. Maybe they are irrelevant objects like users. Maybe a naughty dev put stuff live without going through the proper process.
In all the above cases I want to be able to remove the object from my "pending" list without reverting. I want to ignore them completely.
I am aware of the ability to filter…
1 vote -
Directory and File Locations
Allow the ability to control the location of ALL files/data (permanent and temporary and logging, etc) associated with SSC. This should be asked during setup, but should also be user configurable after install.
1 vote
- Don't see your idea?