588 results found
-
Make it obvious if there any "Get latest" items
When the SQL Source Control tab refreshes, it would be exceedingly useful to see if there are any items under the "Get latest" tab without having to go into the tab.
I would suggest adding the number of changes in the tab to the tab title. For example...
_/ Commit changes (12) _/ Get latest (2) _.....
8 votes -
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 -
I am allowed to commit previous changes that upon refresh would show newer changes. Can there be a check for this on commit?
I want a check on commit for all the items I intend to check in to make sure that there is not a newer version available. In the case where there is, I want to be presented with a list of those changes for review before anything is committed.
2 votes -
Support different static data per customer
I have a single schema for all customers but different reference data for different customers. It would be nice if I could manage this all within SQL Source Control. This should also be understood by SQL Compare and my continuous integration system when it comes time to deploy this to my different environments and customers' sites.
254 votesHi all. Thank you for your votes and feedback on this issue over the years. Here is our current guidance for this suggestion:
Post-deployment scripts give you flexibility for static data
With SQL Source Control, you can now use a post-deployment script to “dynamically” deploy static data based on a factor such as @@SERVERNAME or other query-able conditions.
SQL Source Control introduced pre- and post- scripts in v6.3.
An example post-deployment script which shows how to control deployment of static data by environment is here: https://documentation.red-gate.com/soc7/common-tasks/working-with-pre-post-deployment-scripts/static-data
If you make heavy use of Static Data, we have stronger support for this in SQL Change Automation.
SQL Change Automation:
- Supports column filtered static data tables in the SCA plugin in SSMS
Supports multiple post-deployment scripts, in case there is a preference to manage static data tables in dedicated post-deployment scripts - Allows approaches like bulk loading larger static data tables by supporting SQLCMD…
- Supports column filtered static data tables in the SCA plugin in SSMS
-
run stored procedure before/after commit before/after get
Make a function where you could setup a before/after Commit and before/after Get stored procedure which will be executed automatically.
In my case I backup the Database diagrams to table with a stored procedure. I would like to run it before every commit. The restore sp could be run after a get
3 votes -
9 votes
-
1 vote
-
Search Results in Grid Mode
I still have SSMS Tools Pack installed because of one useful feature that I have not seen in Red-Gate's products. Search Results in Grid Mode. Find all occurrences of your search string in the results in datagrid mode.
12 votes -
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 -
Pending Changes Report
A tool/report that will list all pending changes you have over all databases in a server, currently you have to go through each database one by one seeing if there are any changes
45 votes -
Please make your software more tolerant of slow internet connections with long latencies - like satellite connections.
Please make your software more tolerant of slow internet connections with long latencies - like satellite connections.
2 votes -
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 -
sql source control window resizing
When resizing SSMS, the SQL Source Control window does not resize correctly. Some UI elements appear on top of others. Not a major issue but is likely not working as expected.
3 votes -
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 -
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 -
Exclude/Include filter not working as expected, SLOW performance
we have 13000 objects in our database.
12800 of them are all in the dbo schema which contains the standard logic for our product.
The rest 200 are in the customer specific schema.
We are not interested in source controlling the standard logic, since we get it from our supplier.
We need to source control our customer specific changes. For that every change is made in another schema.
We can perfectly filter the objects out for source control with your tool.
(so they do not appear on the commit screen). However it is very very slow, that's why I suspected…8 votes -
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 -
For shared development environment, replace "GET ALL" with list of historical changes made
When developing in shared enviroment, I'd love a history tab that I can review all revisions with details, and not have to have a modal window separately. I believe this should be integrated into the main source control tab as change history log. This could help make others aware of changes made that could affect them, yet were already committed. Thanks!
7 votes -
When opening SSMS show all databases with differences in the Object Explorer view without having to select each individual database
When opening SSMS highlight all databases with uncommitted changes in the Object Explorer view without having to select each individual database.
4 votes -
On conflict when commiting changes able to right click and open proc/table in new sql editor
When you get conflict when commiting changes it would be nice to be able to right click and open proc/table in new sql editor, do you change (merge) and continue.
14 votes
- Don't see your idea?