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.
I have the same issue on Azure.Richard Mitchell supported this idea ·
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.
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>
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 firstname.lastname@example.org
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?
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.
Currently Data Compare for Oracle doesn't support comparison to scripts which would be a pre-requisite for this feature.
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 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?
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.
54 votesRichard Mitchell responded
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.
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)
I take it that sometimes we don't clear out the pre-existing object name before creating the new name that clashes.
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?
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.
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_'
I presume this is on 12c.
Just to confirm this is because the list doesn’t currently allow multiple rows to be selected currently. Correct?
Is this hide a permanent thing or just until you perform a check-in?
I'm not sure what you mean by this request. Can you clarify?