Richard Mitchell

My feedback

  1. 8 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      3 comments  ·  DLM Automation  ·  Flag idea as inappropriate…  ·  Admin →
      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.

    • 5 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        1 comment  ·  SQL Prompt  ·  Flag idea as inappropriate…  ·  Admin →
        Richard Mitchell commented  · 

        I have the same issue on Azure.

        Richard Mitchell supported this idea  · 
      • 1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Oracle tools » All Oracle tools  ·  Flag idea as inappropriate…  ·  Admin →
          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.

        • 40 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            5 comments  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
            Richard Mitchell commented  · 

            You can do something similar to this via the command line using the filter file from Source Control for Oracle (a very simple xml file).

            We would like to push this feature back into the UI of Schema Compare for Oracle but we think it still needs a little more work to be really what people want.

            For more information see http://documentation.red-gate.com/display/SCO3/Command+line+switches#Commandlineswitches-/filter:<filterfile.scpf>

          • 36 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              planned  ·  3 comments  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
              Richard Mitchell commented  · 

              Actually I'm currently working on that feature for Source Control for Oracle. Once it is complete I'll probably back-port the code in Schema Compare. It's not quite as flexible as the SQL Compare system but I think it's enough.

              If you want to see the experimental build for Source Control for Oracle with filtering just let me know at richard.mitchell@red-gate.com

            • 134 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                14 comments  ·  Oracle tools » Source Control  ·  Flag idea as inappropriate…  ·  Admin →
                planned  ·  Richard Mitchell responded

                We plan on supporting comparison to data using Source Control this year.

                I was wondering what format is best for the data as stored in source control, SQL, CSV, some oracle specific format.

                What do people think?

                Richard Mitchell commented  · 

                That is the plan. I'm leaning towards using csv (or similar) storage on disk for metadata tables as parsing the table is much easier than the SQL approach.

                The work is planned for this year.

                Richard Mitchell commented  · 

                Currently Data Compare for Oracle doesn't support comparison to scripts which would be a pre-requisite for this feature.

              • 3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
                  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?

                • 18 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    5 comments  ·  Oracle tools » Source Control  ·  Flag idea as inappropriate…  ·  Admin →

                    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?

                    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/

                  • 54 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      4 comments  ·  Oracle tools » Source Control  ·  Flag idea as inappropriate…  ·  Admin →

                      You can now use Mercurial in the v3 release of the tool by using “Working folder” which saves changes to disk and allows you to use external tools to commit and retrieve your changes.

                      Richard Mitchell commented  · 

                      I know this isn't ideal but in our current Git beta there is a feature called "Working folder" which allows you to link Source Control for Oracle to an artbitrary directory on disk which itself can be under source control via Mercurial.

                      It is perhaps worth trying out.

                      (The work that I've done adding Git support should make Mercurial support easier in the future)

                    • 1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        2 comments  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
                        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.

                      • 52 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          8 comments  ·  Oracle tools » Source Control  ·  Flag idea as inappropriate…  ·  Admin →
                          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
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            under review  ·  3 comments  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
                            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.

                            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
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Oracle tools » Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
                              Richard Mitchell commented  · 

                              I presume this is on 12c.

                            • 3 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                2 comments  ·  Oracle tools » All Oracle tools  ·  Flag idea as inappropriate…  ·  Admin →

                                Just to confirm this is because the list doesn’t currently allow multiple rows to be selected currently. Correct?

                                Richard Mitchell commented  · 

                                Is this hide a permanent thing or just until you perform a check-in?

                              • 5 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  Oracle tools » Source Control  ·  Flag idea as inappropriate…  ·  Admin →
                                  Richard Mitchell commented  · 

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

                                Feedback and Knowledge Base