Command Line filter
amorts
Posts: 7
Hi,
How can I create a filter file if I don't have source control for Oracle?
Is it possible to manually create a filter file?
Thanks
How can I create a filter file if I don't have source control for Oracle?
Is it possible to manually create a filter file?
Thanks
Comments
The Object Filter feature now available in Source Control for Oracle is a recent addition to the product. Unfortunately it is not yet available in Schema Compare for Oracle where you can generate a filter file and save it. However there are plans to introduce this feature in a future version of Schema Compare for Oracle, as this User Voice Forum ARTICLE. Please do vote and comment on the User Voice article.
The only work around I can suggest, is to set the comparison via the Schema Compare for Oracle UI, review the comparison results and then filter out the unwanted objects. Save the project file and use the created project file in your command line comparison.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
In the project itself I do have the Indexes object type unchecked in the 'filter setup' pane. However, when I run the comparison using this project from the command line I the indexes are output in the comparison report??
In the very latest version you can use a filter file /filter:<filterfile.scpf> (currently only generated by Source Control for Oracle, but it's a simple XML file so nothing too onerous) to exclude object types and object names based on substrings.
http://documentation.red-gate.com/displ ... mmand+line
The filter in Source Control for Oracle is much more powerful and it's this that I plan on extending and back-porting into both Schema Compare and Data Compare in the future.
Project Manager
Red Gate Software Ltd
sco.exe /project:./Local_vs_Ref.ocp /scriptfile:"./Deploy/temp/Local_vs_Ref_Changes.sql" /report:"./Deploy/temp/Reports/Local_vs_Ref.html" /reporttype:Interactive /filter:"./Filter.scpf"
The filter file looks like:
The generated script file includes type with exclude string.
Any hints?
Having a read through the code it all seems in order.
Project Manager
Red Gate Software Ltd