Settings and activity
10 results found
-
12 votes
While we haven’t implemented this exact feature, I want to share some information with similar patterns which may help some readers, or inspire comments or feedback in others.
One common approach is to manage multi-database deployments via an orchestrator, such as Azure DevOps, Octopus Deploy, or similar. This may be managed concurrently or in a simple loop depending on the needs. One example of this with Azure DevOps is demonstrated here: https://www.youtube.com/watch?v=-rZxLCRrgmI
When using a single release artifact to deploy to many databases, it’s important that you control for database drift on a regular basis outside of the deployment process. One way to do that is to set up monitoring that alerts you to schema changes that occur. An example of monitoring for this in SQL Monitor is in this custom metric: https://sqlmonitormetrics.red-gate.com/unauthorized-object-changes/
An error occurred while saving the comment -
1 vote
We have an Early Access Program for a migrations-first solution for Oracle version control and deployments. Please see more details and sign up at https://documentation.red-gate.com/ddfo/other-resources/migrations-based-deployments-early-access-program.
An error occurred while saving the comment 
Richard Mitchell
commented
Do you mean creating a script to run later? If so you can already do that in both the UI and the command line - see https://documentation.red-gate.com/display/SCO3/Examples+-++using+the+command+line for an example of doing it on the command line.
-
3 votes
An error occurred while saving the comment Richard Mitchell
commented
Are you talking about via the command line or the UI?
In the UI the objects should by default be grouped by "Type of difference" - top right of the window. This allows an easy way to move between changed objects using the cursor keys.
Is that what you mean?
-
21 votesRichard Mitchell
responded
I’m not sure how generally useful this feature would be. I’m trying to understand your use case to see what problem you’re trying to solve.
Could you give me more details?
An error occurred while saving the comment Richard Mitchell
commented
OK this does sound like I presumed a possible scenario for a new tool we're developing called DLM Dashboard. Currently it's only for SQL Server although we're looking into the possibility of creating Oracle version.
-
4 votes
An error occurred while saving the comment Richard Mitchell
commented
I take it that sometimes we don't clear out the pre-existing object name before creating the new name that clashes.
-
54 votes
An error occurred while saving the comment Richard Mitchell
commented
So I imagine what we would do is compare the file script and the database script in a merge tool and then on resolve that would become the new file script to be applied to the database.
Is that what people are imagining?
-
6 votes
An error occurred while saving the comment Richard Mitchell
commented
Annoyingly I think you could do this via a filter mechanism I've added into Source Control for Oracle lately. I am planning on back-porting it into Schema Compare at some point in the future. This would allow you set a textual object filter to exclude objects with names containing "ggs_" - would that be enough?
I'm trying to avoid option proliferation, although it's no great problem for most users.
An error occurred while saving the comment Richard Mitchell
commented
In the DBA_LOG_GROUPS table what is the value of the GENERATED column? I'm expecting 'GENERATED NAME' for system generated names. The name prefix 'ggs_' doesn't seem like a system generated name as these normally start with 'sys_'
-
3 votes
An error occurred while saving the comment Richard Mitchell
commented
I presume this is on 12c.
-
3 votes
Just to confirm this is because the list doesn’t currently allow multiple rows to be selected currently. Correct?
An error occurred while saving the comment Richard Mitchell
commented
Is this hide a permanent thing or just until you perform a check-in?
-
5 votes
An error occurred while saving the comment Richard Mitchell
commented
I'm not sure what you mean by this request. Can you clarify?
If you don't want to do this via automation you could try our SQL Multi Script tool which can query and run queries against many many databases and servers at once.