Toad World® Forums

create schema compare


#1

Hi,

Can someone help me to find some tutorial material for creating schema
compare using Toad 10.1.1 command line. I’ve created the below text file but
seems to be missing connection to target schema, ace@co4v.test01.bfix. I use
the command line:

“C:\Program Files\Quest Software\Toad for Oracle\toad.exe” -c
ACE/@CO4V.DEV01.BFIX
CMDFILE=c:\mycommandfile.txt

You can create a schema script from a command line

using this file with a few modifications.

Lines that start with a # are comments.

Calling TOAD like this will invoke the generate schema script screen

#, from command line :

“C:\Program Files\Quest Software\Toad for Oracle\toad.exe” -c

ACE/@CO4V.DEV01.BFIX
GSS="\home6\walee1$\checkout\Toad\table.txt"

Obviously, your path to TOAD may differ, along with your connect info.

The file name after “GSS=” is the name of this file.

To disable the Team Coding login prompt:

Add “TC=NO” (without the quotes) in the command line string.

You can also generate a schema script from a command file like this:

“C:\Program Files\Quest Software\Toad for Oracle\toad.exe” -c

ACE/@CO4V.DEV01.BFIX
CMDFILE=c:\mycommandfile.txt

Where mycommandfile.txt might look like this, first generating a schema

script,

then performing an index rebuild, then a schema comparison and finally

building

some html schema documentation.

GSS=c:\schemascript.txt

RMI=c:\indrebuild.txt

COMP=c:\schemacomp1.txt

GENHTML=c:\html1.txt

When you start TOAD with the GSS command line option, the generation of

the schema

script will start automatically. So there are only two possible

commands, one to close

the Generate schema script window, and one to close TOAD after the script

is created.

Do not put more than one command per line. Do not leave spaces before

the commands.

Command Summary :


#2

The tutorial that you were looking at was for older versions of Toad. This is
now done in the Automation Designer.

Look on the main toobar - there is a button for “Automation
Designer”. It has a gear & pencil icon on it. You can set up schema
compares to execute from command line there. Hit F1 when you get there and
you’ll have plenty of info about it.

-John


#3

There were several blogs on toad world on how to do this as well – and
some coffee bite videos I believe too


#4

Thank you John Dorlon.

John Dorlon wrote:

The tutorial that you were looking at was for older versions of Toad.
This is now done in the Automation Designer.

Look on the main toobar - there is a button for “Automation Designer”.
It has a gear & pencil icon on it. You can set up schema compares to
execute from command line there. Hit F1 when you get there and you’ll
have plenty of info about it.

-John