Home » SQL & PL/SQL » Client Tools » TOAD - Command Line - Compare Schema's (TOAD 9.5.0.31)
TOAD - Command Line - Compare Schema's [message #290276] Fri, 28 December 2007 04:39 Go to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Toad has a nice feature where you can perform some stuff with scripts. One of those is Compare Schema's, which we use to - well - compare schema's (our development database against our production database for instance) to figure out what is not yet promoted.

We've set this up a while ago (TOAD version 9.0.1) and it worked well.

During a normal TOAD-session one can configure which connection(s) and/or schema(s) you like to compare. In the options-tab you select/deselect the object-types to include in the compare.
Hitting the compare button will get the comparisation going.
But you can also hit the save-button, which will save all your options in a simple text-file.

This text-file can then be used at command line to perform the compare.

Strangely enough using the text-file generated by TOAD version 9.5.0.31 issues following error/log message:

Reference and Comparison Sources Not Selected

The same procedure did work with previous version of TOAD however: version 9.0.1

Getting into google with the above message doesn't provide me with useful pages.

Any of you using TOAD like this and could shed some light?


Re: TOAD - Command Line - Compare Schema's [message #290425 is a reply to message #290276] Fri, 28 December 2007 16:46 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Simply open a case https://support.quest.com/SUPPORT/index?page=home
Re: TOAD - Command Line - Compare Schema's [message #292306 is a reply to message #290425] Tue, 08 January 2008 08:54 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
andrew again wrote on Fri, 28 December 2007 23:46

Simply open a case https://support.quest.com/SUPPORT/index?page=home


I did and apparently this is considered as a bug and will be fixed in the near future ...
Re: TOAD - Command Line - Compare Schema's [message #320696 is a reply to message #290276] Thu, 15 May 2008 23:56 Go to previous messageGo to next message
lxy220634
Messages: 2
Registered: May 2008
Junior Member
I want to konw What did you do in batch file.
Can you email the file to my?
Thanks!

Email : xu_hai_hui@163.com
Re: TOAD - Command Line - Compare Schema's [message #320699 is a reply to message #320696] Fri, 16 May 2008 00:19 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What do you mean? There's no reference to any batchfile in this thread.
Re: TOAD - Command Line - Compare Schema's [message #320803 is a reply to message #320699] Fri, 16 May 2008 05:01 Go to previous message
lxy220634
Messages: 2
Registered: May 2008
Junior Member
I hope to do schema compare automaticlly!
I want to know how did you do in toad 8.6 .
Previous Topic: How can I change the background colour of SQL PLUS?
Next Topic: Integrating with PL/SQL stored procs from Java/J2EE apps
Goto Forum:
  


Current Time: Wed Dec 07 12:36:30 CST 2016

Total time taken to generate the page: 0.23081 seconds