Toad World® Forums

ORACLE TOAD compare version 12 versus 13

We are using toad-compare(version 12.9) via commandline for several years.
Now we are evaluating to upgrade to version 13.1.15.

We start something like:
Toad.exe -a "App1->compare | bbxdoc_user.ini"

With a v12 .ini like:
[2]
Name=compare
Type=Compare Schemas
ConnectionCount=1
Connection_1=DUO_ADMIN@ORCL
ObjectTypesToCompare=Check Constraints, Comment, Materialized View Comment, Materialized View Column Comment, Table Comment, Table Column Comment, View Comment, View Column Comment, Constraint, Type, Type Body, FK Constraints, Index, Java Source, Package, Package Body, PK Constraints, Procedure, Queue, Queue Table, Sequence, Private Synonyms, Synonym, Datatype, Table, Trigger, Type, View, Function, Grant, Unique Constraint
Options=Schema Compare, FORCE views, Ignore Con Name Diffs, Ignore Case in PLSQL Comparisons, 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, Storage, Comp Tablespace, View Columns, Drop/Create Seq, No Comp Col Order, ComparePrivateSynTargetSchema, NoSupplementalLogging, Dont compare schema name in trigger desc, Inc Prompt Cmds, Deps in Script Comments, Script Comments, Not Like
ReferenceConnection=DUO_ADMIN@ORCL
ReferenceSchema=UTILS_DAO
DefFileOutput=
DefFile=
UseObjectNamesLike=TRUE
ObjectNamesLike=SYS_%;SYSTP%;SYS_PLSQL%;AQ$%;M$%;SCHEDULER$%;GG_%
ObjectTS=
ExclusionFile=
DiffLimit=100000
TargetConnection1=DUO_ADMIN@DUORS-T
TargetSchema1=UTILS_DAO
TargetDefFile1=
TargetDefFileOutput1=
TargetSummaryOutput1=utils_dao_summary.htm
TargetDetailedOutput1=utils_dao_difference.txt
TargetScriptOutput1=utils_dao_script.sql
TargetEmailSummary1=FALSE
TargetEmailDetails1=FALSE
TargetEmailScript1=FALSE

In V19 the options seem to be changed, I cannot find documentation how to use the options.
Especially the options below are unclear to me (I got them via the TOAD-UI save to clipboard):
object TarCompareSchemas
Enabled = True
...
RunData = {
545046300A54617252756E44617461000B416374696F6E536574494402000249
440200084661696C4D6F6465070A666D436F6E74696E75650653746174757307
096173537563636573730000}
Logins = {
545046300A544C6F67696E5265637300054974656D730A8B0100005450463009
544C6F67696E526563000B4175746F436F6E6E6563740805436F6C6F720400FF
FF0009436F6E6E656374417306064E4F524D414C11456E637279707465645061
7373776F7264062C5A4A31567A6341665641786F464F7A6F3167453847644A52
75347A7643594B2F524F366377624D6F57694D3D084661766F72697465080447
55494406267B43384630373844362D333735362D344643312D424535422D3132
344543324131364336427D0B4C617374436F6E6E65637405008815940FB402AB
0E40064D6574686F640200064E756D62657202000A4F7261636C65486F6D6506
51463A5C6769745C7267665C4E53465C696E6672617374727563747572655C69
6E7374616E74636C69656E745F31395F335C57696E646F77735C414D4436345C
696E7374616E74636C69656E745F31395F331052656C6174697665506F736974
696F6E020C0F53657373696F6E526561644F6E6C79080C536176655061737377
6F72640806536572766572060744554F52532D540455736572060944554F5F41
444D494E00000000}
SchemaItems = {
545046300F54536368656D614974656D4C69737400054974656D730AAE000000
545046300B54536368656D614974656D0013536F75726365436F6E6E65637453
7472696E67061144554F5F41444D494E4044554F52532D540C536F7572636553
6368656D61060944554F5F41444D494E0D436F6E6E656374537472696E670611
44554F5F41444D494E4044554F54542D5006536368656D61060944554F5F4144
4D494E0C456D61696C53756D6D617279080C456D61696C44657461696C73080B
456D61696C5363726970740800000000}
end

Is a manual available explaining the options in the V19 .ini file?

The first file is a parameter file, created by right-clicking an action (on the right hand side of the automation designer) and choosing "create parameter file".

The 2nd file is an export file, created by right-click an app (or using toolbar) on the left hand side of the automation designer, and choosing "Export".

You can perform both of these actions in 12.9 and 13.1.

Thanks for the reply.
I know how to create the .ini file via TOAD.
But, I want to generate the .ini file via a script, we have a lot of databases with a lot of environments.
In version 12.9 it was very easy to generate the file, the only parameters we had to change was
ReferenceConnection=...
ReferenceSchema=...
TargetConnection1=...
TargetSchema1=...

In that way we can compare any environment without having to go via de TOAD user-interface (compare).

Now in V19 some new properties are added, which are unclear to me:
RunData=...
SchemaItems=...

Is documentation available so I can generate the v19 .ini files?

The parameters have not changed. You are using the wrong file. The screen shot below is of the latest version of Toad, version 13.2:
image

This is the file it produces:

Then, to use the file, as you said:
Toad.exe -a "App->Compare Schemas1 | c:\Temp\Compare Schemas1.ini"

The file that you are trying to use, the wrong file, the one with RunData and SchemaItems, was created like this:


You should only use that file when Exporting the action from one copy of Toad and Importing it to another copy of Toad.

I understand now! Thanks...