Activity overview
Latest activity by planetawylie
eddie davis wrote:
Thank you for your support request.
A support call has been created for you HERE. (You may need to create a RedgateID to be able to view and update it.)
Can you please update the call or send an email to [support@red-gate.com] quoting call reference #24022, with an example of what you are experiencing?
Please check to see if you have the 'Trim trailing spaces' option selected or enabled? Edit project ->Options tab ->Comparison Behavior section ->Trim trailing white space.
Many Thanks
Eddie
Hi,
I already have the 'Trim trailing white space' option selected. And what would need to be uploaded to the support team, two blobs that were compared? If so, I'll need to anonymize everything in it first.
Thanks, Andrew / comments
eddie davis wrote:
Thank you for your support request.
A support call has been created for you HERE. (You may need to create a RedgateID to be able to view and update it.)
Can you please update ...
BLOB showing up as changed even though no changes
Hi,
When I compare 2 tables for changes, the BLOB data is compared and shows up in the final output script sql as an UPDATE, even though nothing changed.
What would cause this to happen? How is the...
Data compare output SQL file - DECLARE sections
Hi, when the SQL script file is produced for a data compare, you get the typical, eg:
DECLARE
null_value CHAR(#) := NULL;
statement1 CHAR(#);
BEGIN
statement1 := 'some statement'
EXECUTE IMMEDIATE ...
richardjm wrote:
The full command line documentation is at http://documentation.red-gate.com/displ ... mmand+line (we're working on the documentation currently)
You'll need to modify the /behaviour and /ignore options but this should give you just as much control over the tool as using the Schema Compare for Oracle UI.
Hi, are not those only applicable to when a target/source approach is used?
I'm trying to use the -project approach. It makes more sense for us to set up project files and run the diffs using those than to define the switches against a source/target setup, especially in our automated diff process. We can just download a new project file with all the settings in it (previously tested using the GUI) and let the automated builder pick it up.
And when I am using the source/target approach, I was defining my switches incorrectly. For example, I thought I could do '-b hfder' but you actually have to do each one with a separate '-b'.
Thanks, Andrew / comments
richardjm wrote:
The full command line documentation is at http://documentation.red-gate.com/displ ... mmand+line (we're working on the documentation currently)
You'll need to modify the /behavi...
richardjm wrote:
This is now available. Just hit check for updates in the help menu or re-download it.
Hi, thanks for the update. I downloaded/installed and changed my script to use the project file again. Unfortunately it still says there are not differences between the schemas when using the -project approach, when there are.
Also, of the new switches added, which of them removes the schema names from the output script file?
Thanks, Andrew / comments
richardjm wrote:
This is now available. Just hit check for updates in the help menu or re-download it.
Hi, thanks for the update. I downloaded/installed and changed my script to use the projec...
richardjm wrote:
I've just had a look and it seems like there are number of recent options that hadn't made it into the command line. I've just fixed this so it'll be in the next release (hopefully very soon, days/weeks).
Also another possible confusion is that specifying any option either via -ignore or -behaviour clears all the default options. Again I've added information in the command line help to make this clearer what the current defaults would be.
Glad DCO is working for you at least [image]
Hi Richard, thank you for the fast turnaround, that is great news, looking forward to the new version!
Thanks / comments
richardjm wrote:
I've just had a look and it seems like there are number of recent options that hadn't made it into the command line. I've just fixed this so it'll be in the next release (hopefu...
Command line vs GUI results are different
Schema Compare for Oracle v3.0.1.124
Hi,
I'm evaluating the SCO with the intent to integrate it into my CI build process, to produce a schema (and later data using DCO) comparison from one release ...