Toad World® Forums

ExclusionFile seems to make no difference to Schema Compare


#1

Hi,

I am using Toad DevOps Toolkit to perform a schema compare of two oracle database schemas. I wish to exclude from the comparison a PL/SQL Package and so have created an exclusion file that contains the following two lines ( it is based upon the exclusion file generated by TOAD Automation Designer Schema Compare as I had no other reference for what one should look like):

Package Body:PKG_LND
Package:PKG_LND

I provide the location to this file to TDT by assigning it to the ExclusionFile (where $EXCLUSION_ FILE is a variable containing the full path to the exclusion file):

$TDT.CompareSchemas.ExclusionFile = $EXCLUSION_FILE

However, whenever the comparison runs, the PKG_LND still appears in the generated sync script. Am I doing something wrong or is this a bug ?

Thanks in advance for your help,

Jonathan.


#2

That’s a bug. It was reported earlier (internally I think) and is fixed for the next version.

It uses the same file as Toad, so your assumption was correct.


#3

Thanks for the quick response. So it should be available in release 1.3 of Toad DevOps Toolkit ? Do you have a date when the next release will be available ?


#4

1.3, correct. As for the date, it’s not set yet as far as I know.


#5

Okay. Thanks, I’ll keep a lookout for it.