RE: Schema comparison from Command line

A long time ago a new more powerful way to run toad from command line was implemented - it's called actions. Then with each release screens were reworked to use this new facility - and to no longer use the old command line engine. So -c is no longer an option - it has been replaced by the infinitely more powerful -a command line option. There have been tons of material written about this and how to best use it. My advice is to start with the online help to get some basics, then read several great blogs on toad world covering toad's app designer and running apps from command line, plus Mark Lerch the key developer on this wrote some white papers which I believe are both on toad world and the yahoo groups and/or toad community in the files section. Read all that and then come back if there are questions ......

From: [email protected] [mailto:[email protected]] On Behalf Of vg_sreekumar
Sent: Wednesday, February 08, 2012 5:20 AM
To: [email protected]
Subject: [toad] Schema comparison from Command line



Hi Experts,
i am trying to compare two schema from command line. Once i given the command toad getting started for the first schema and getting an error

"The scehma compare has been converted to an action and is now run from command line using the action palette. To load settings file in the new schema compare window, do a ctrl+alt+shift in the "Target Schemas" grid. See "Actions" in the help file for more information."

---------
Below is the details further

I have created one file "comp.txt" Created in C:\DB_Scripts\compare_Schema folder. Executed the command from command line
C:\Program Files\Quest Software\Toad for Oracle>"toad.exe" -c "xx/xxxx@xx" comp="C:\DB_Scripts\compare_Schema\comp.txt"

is any one seen this kind of error?
Can anyone Please help me how to compare the schema step wise how you guys are doing ?

Thanks in advance

File content is pasted below
--------------------------------
#
# You can run the schema comparison from a command line
# using this file with a few modifications.
#
# Lines that start with a # are comments.
#
# Calling TOAD like this will perform a comparison from command line :
#
# "D:\ArchivedToads\Toad96\toad.exe" -c "xxxx/<7,0,0,0,125,39,190,229,94,136,8,42,245,147,160,75,164,105,193,194>@xxxx" COMP="C:\DB_Scripts\compare_Schema"
#
# Obviously, your path to TOAD may differ, along with your connect info.
# The file name after "COMP=" is the name of this file.
#
# Uncomment and edit the following line to load a saved object set
# from a text file.
#LoadObjectSet('C:\DB_Scripts\compare_Schema\MyObjectSet.txt')
#
# To disable the Team Coding login prompt:
# Add "TC=NO" (without the quotes) in the command line string.
#
# Uncomment any or all of the following lines for actions to perform
# after the comparison. The file names are of course editable. Do
# not put more than one command per line. Do not leave spaces before
# the commands. Email settings are taken from 'View' ->
# 'Options' -> 'Email Settings'.
#
# Note : Some mail servers do not handle rtf formatted mail.
# Use the text option if it is not formatted correctly.
# As a workaround, RTF files are included as an attachment.
#
#SaveInteractiveResultsAsText('C:\DB_Scripts\compare_Schema\InteractiveResultsFile.txt')
#SaveRTFResultsAsRTF('C:\DB_Scripts\compare_Schema\RTFResultsFile.rtf')
#SaveRTFResultsAsText('C:\DB_Scripts\compare_Schema\RTFResultsFile.txt')
#SaveSummaryAsRTF('C:\DB_Scripts\compare_Schema\SummaryResultsFile.rtf')
SaveSummaryAsText('C:\DB_Scripts\compare_Schema\SummaryResultsFile.txt')
#SaveSyncScript('C:\DB_Scripts\compare_Schema\SyncScript.sql')
#EmailInteractiveResultsAsText
#EmailRTFResultsAsRTF
#EmailRTFResultsAsText
#EmailSummaryAsRTF
#EmailSummaryAsText
#EmailSyncScript
CloseComparison
CloseTOAD
#
#
# Passwords are encrypted. You can replace the encypted with its
# unencrypted form if you wish.
# CONNECTREF=user/password@db
# CONNECTCOMP=user/password@db
#
CONNECTREF=xxxx/xxxx@SSDEV01
CONNECTCOMP=xxxx/xxxx@SSREF00
cboReferenceLoadedSchema|xxxx@SSDEV01
cboRefSchema|xxxx
cboReferenceExportFile|
cboTargetLoadedSchema|xxxx@SSREF00
cboTargetSchema|xxxx
cboTargetExportFile|
btnCommentsTab|0
btnCommentsTabCols|0
btnCommentsView|0
btnCommentsViewCols|0
btnViewColPrec|0
btnCommentsSnap|0
btnCommentsSnapCols|0
btnDatabaseLinks|0
btnContext|0
btnSpecifyObjectSet|0
seDiffLimit|1000
btnDirectories|0
btnFunctions|0
btnDimensions|0
btnGrants|0
btnIndexes|0
btnJavaSource|0
btnLibraries|0
btnOutlines|0
btnPolicies|0
btnPolicyGroups|0
btnPackages|0
btnPartitions|0
btnProcedures|0
btnSynonyms|0
btnPubSyn|0
btnSequences|0
btnSnapshots|0
btnSnapshotLogs|0
btnTriggers|0
btnTables|1
btnRefreshGroups|0
btnQueues|0
btnQueueTables|0
btnClusters|0
btnConstraints|0
btnNoRecycle|0
btnFKConstraints|0
btnPKConstraints|0
btnUKConstraints|0
btnCheckConstraints|0
btnDatatypes|0
btnViews|0
btnStorage|0
btnTablespace|0
btnLobs|0
btnLogging|0
btnCache|0
btnCompress|0
btnMonitoring|0
btnDegree|0
btnInstances|0
btnPctFree|0
btnPctUsed|0
btnIniTrans|0
btnMaxTrans|0
btnInitial|0
btnNext|0
btnMinExtents|0
btnMaxExtents|0
btnPctIncrease|0
btnFreelists|0
btnFreelistGroups|0
btnBufferPool|0
btnRowCount|0
btnCurrVal|1
btnDropCreateSeq|1
btnObjNamesLike|0
btnAnalyzed|0
btnSelStar|0
cbSlash|0
cbSetDefineOff|1
cbSQLPlusPrompt|1
btnSpecifyObjectSet|0
btnNoWhiteSpace|0
btnNoDoubleQuotes|0
btnNoCodeComments|0
btnIgnoreCase|0
btnStats|0
btnFormat|0
btnSchemaName|0
btnNoParseTriggers|0
btnNoCompDesc|0
btnNullBlank|0
btnNoByteChar|0
btnNoPrec|0
btnNoColOrder|0
btnNoCompSeqMinVal|1
btnNoCompStatus|0
btnIncludeComments|0
btnLikeCaseSens|0
btnLikeNotLike|0
btnShowDependencies|0
EditObjNamesLike|A%
txtExportFile|
btnReferenceLoadedSchema|1
btnReferenceExportFile|0
btnTargetLoadedSchema|1
btnTargetExportFile|0

Thanks
Sreekumar V G