Search the web
Sign In
New User? Sign Up
toad · Self Help List for TOAD Development Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Click here for the latest updates on Groups Message search

Messages

  Messages Help
Advanced
Compare schemas problem   Topic List   < Prev Topic  |  Next Topic >
Reply < Prev Message  | 
When I compare schemas from 2 instances, all my code objects are listed as
different. Show Difference Details tells me that there is one extra blank line
just before the final '/' in the code objects of one instance.
The only difference I can think of is that instance is characterset AL32UTF8,
and the other is WE8MSWIN1252. No such problem for two instances with
WE8MSWIN1252. (The first instance was "converted" from the second.)

Very tedious to inspect all those code objects individually. (Oddly, no such
problem comparing single code objects, only when using compare schemas.)

Here's a suggestion that might help with this, and might also be pretty useful
generally.

In "File Comparison Rules"/"Define Minor", add an option to "ignore blank
lines".

Oh yeah, I'm using Toad 9.6.1.1 and instances are all Oracle 10g.




Wed Jul 8, 2009 6:30 pm

gerry_rondot
Offline Offline
Send Email Send Email

< Prev Message  | 
Expand Messages Author Sort by Date

When I compare schemas from 2 instances, all my code objects are listed as different. Show Difference Details tells me that there is one extra blank line just...
gerry_rondot
Offline Send Email
Jul 8, 2009
6:57 pm

... Better: add an option to "ignore white space" which would include blank lines. Roger S. PLEASE NOTE: This communication, including any attached...
Simoneau, Roger
rsimonea@...
Send Email
Jul 8, 2009
7:11 pm

Look on the schema compare screen. Among the options is a place to ignore whitespace. If you check that, the ones that only differ by whitespace won't even...
John Dorlon
jdorlon3
Offline Send Email
Jul 8, 2009
7:16 pm

You're right! I had missed that option. Thanks....
gerry_rondot
Offline Send Email
Jul 14, 2009
7:43 pm
Advanced

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help