Schema comparison from Command line
"vg_sreekumar" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
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
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/