Skip to content

Settings and activity

10 results found

  1. 12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    under review  ·  Kendra responded

    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
    Richard Mitchell commented  · 

    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.

  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Oracle » All Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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?

  4. 21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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.

    http://www.red-gate.com/products/dlm/dlm-dashboard/

  5. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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.

  6. 54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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?

  7. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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_'

  8. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Richard Mitchell commented  · 

    I presume this is on 12c.

  9. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Oracle » All Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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?

  10. 5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Richard Mitchell commented  · 

    I'm not sure what you mean by this request. Can you clarify?