Toad World® Forums

TOAD compare via automation manager -

I installed TOAD 14.1 and try to launch (compare 2 schemas)
Toad.exe -a "App1->comparecdc | comparecdc.ini"

I get the error "Unable to create directory", it is not clear to me which directory is not created and why.

Capture

Try giving the full path to comparecdc.ini

Content of comparecdc.ini: (I tried various things with BaseOutputFolder)
[186]
Name=comparecdc
Type=Compare Schemas
ConnectionCount=1
Connection_1=TERMINUS_ADMIN@ORCL
ObjectTypesToCompare=Check Constraints, Cluster, Comment, Materialized View Comment, Materialized View Column Comment, Table Comment, Table Column Comment, View Comment, View Column Comment, Constraint, Context, Type, Type Body, Database Link, Dimension, FK Constraints, Index, Java Source, Library, Outline, Package, Package Body, Partition List, PK Constraints, Policy, Policy Group, Private Synonyms, Procedure, Queue, Queue Table, Refresh Group, Sequence, Materialized View, Materialized View Log, Synonym, Table, Trigger, View, Function, Grant, Unique Constraint, Audit Policy, Redaction Policy, Redaction Policy Column, Zone Map, Attribute Dimension, Hierarchy, In Memory Join Group, Analytic View
Options=Analyzed, Schema Compare, FORCE views, Include Schema Name, UpperCase like search, No Comp Seq Minval, No Recycle Bin Objects, No White Space, Null=Blank for col defaults, No Double Quotes, Inc. Set Define Off, Sort, View Columns, Drop/Create Seq, MVAliases, IncludeByteChar
UseObjectNamesLike=FALSE
ObjectNamesLike=A%;B% {"Object Names Like" String}
ObjectTS=
ExclusionFile=
DiffLimit=1000
BaseOutputFolder=Z:\Temp\toadabc
OutputSourceSnapshotFile=FALSE
OutputTargetSnapshotFiles=FALSE
OutputComparisonResultDetailFiles=TRUE
OutputComparisonResultSummaryFiles=TRUE
OutputComparisonResultSyncFiles=TRUE
OutputComparisonResultDetailEmail=FALSE
OutputComparisonResultSummaryEmail=FALSE
OutputComparisonResultSyncEmail=FALSE
SourceConnection1=TERMINUS_ADMIN@ORCL
SourceSchema1=TERMINUS_ADMIN
SourceDefFile1=
TargetConnection1=TERMINUS_ADMIN@TERMINUS-P
TargetSchema1=TERMINUS_ADMIN
TargetDefFile1=

Thanks a lot! This seems to work, is this new and intended behavior?
(currently we use toad 12.9 in all of our compare scripts, in that version it works without)

I'm not sure. What folder is that ini file in?

My test setup is on the root of my z-drive:
Toad.exe -a "App1->comparecdc | z:\comparecdc.ini"

When I run from a sub-folder same...
Z:\othertest>Toad.exe -a "App1->comparecdc | comparecdc.ini"
--> This does not work

When I prefix with ./
Z:\othertest>Toad.exe -a "App1->comparecdc | .\comparecdc.ini"
--> This works

I think it is always best to specify the folder, but we need to give a better message when you don't.

I'll fix that.

Thanks!
Since all the compare scripts are generated, it is a small fix for me to add the path...