RE: Re: Schema Comparison Nusiances 11.6.1
John Dorlon <[email protected]> Tue, 23 Apr 2013 19:50:29 +0000
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <4120B436C765EC43A31CC3E2A13D36A62643736D@ALVMBXW02.prod.quest.corp> |
--_000_4120B436C765EC43A31CC3E2A13D36A62643736DALVMBXW02prodqu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable These features are reserved for DBA module only. From: [email protected] [mailto:[email protected]] On Behalf Of ss052= 111 Sent: Tuesday, April 23, 2013 2:30 PM To: [email protected] Subject: [toad] Re: Schema Comparison Nusiances 11.6.1 Another Compare Schemas problem. I'm running v11.6.1.6. I've done my compare, and I'd like to run the sync script. I see my script,= but the buttons "Save", "Move Script to Editor", "Move Script to Editor an= d Run Now", and "Schedule Script" are all grayed out. It seems the only opt= ion I have is to print the script. If I try to select and copy the script, = it does not go to the clipboard. The only way I've had any success at all is to print the script to CutePDF,= but even then the script has line numbers, headers, etc. which prevent it = from being too much use. I also tried setting the Sync Script output file on the "Define Target Sche= ma and Output" window. I was excited to see my output file until I realized= that Toad only wrote the header information, but none of the actual DDL. Has anyone else seen this behavior? Sean --- In [email protected]<mailto:toad%40yahoogroups.com>, John Dorlon <jo= hn.dorlon@...<mailto:john.dorlon@...>> wrote: > > I see that. Also fixed for next beta. > > Thanks. > > > From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:toad@ya= hoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of chuckoneal99 > Sent: Monday, December 31, 2012 9:40 AM > To: [email protected]<mailto:toad%40yahoogroups.com> > Subject: [toad] Re: Schema Comparison Nusiances 11.6.1 > > > > I've noticed another one while changing sources and targets multiple time= s in the same schema comparison window. After a new source connection is de= fined the schema drop down does not refresh. It does refresh the schemas af= ter picking the new connection again from the drop down list. Shouldn't the= schema dropdown refresh when the connection is established? I'm not connec= ting as a schema owner if that matters. > > --- In [email protected]<mailto:toad%40yahoogroups.com><mailto:toad%40= yahoogroups.com>, John Dorlon <john.dorlon@<mailto:john.dorlon@<mailto:john= .dorlon@%3cmailto:john.dorlon@>>> wrote: > > > > Thanks Chuck. Both are fixed in the next beta. > > > > > > From: [email protected]<mailto:toad%40yahoogroups.com><mailto:toad%4= 0yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.co= m><mailto:toad%40yahoogroups.com>] On Behalf Of chuckoneal99 > > Sent: Sunday, December 30, 2012 4:09 PM > > To: [email protected]<mailto:toad%40yahoogroups.com><mailto:toad%40y= ahoogroups.com> > > Subject: [toad] Schema Comparison Nusiances 11.6.1 > > > > > > > > I'm in the middle of comparing ~25 schemas for first of 4 separate envi= ronments to a baseline for the first of many times and want to point out a = few annoyances in 11.6.1. > > > > 1. Select source schema definition file, click in and define target, OK= to return to Options and the source is blanked. > > 2. The ellipse always open User Files. Two days later I have the revela= tion of copying all of the SDXML files there, but it would be nice if it co= uld remember the prior paths. > > > > My goal is to make this a repeatable process using the Automation Desig= ner. I'm thinking I need generic schema specific source/target.SDXML files = vs. the default SID/timespamped file names. Same goes for the sync scripts = and report files. > > > > This is an incredibly powerful combination of tools I feel is somewhat = under-advertised. Who doesn't, or better, who shouldn't be routinely compar= ing development/test environments to pre-established baselines. > > > --_000_4120B436C765EC43A31CC3E2A13D36A62643736DALVMBXW02prodqu_ Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit <head> <style type="text/css"> <!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none; } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> </style> </head> <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} code {mso-style-priority:99; font-family:"Courier New";} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} tt {mso-style-priority:99; font-family:"Courier New";} span.cat {mso-style-name:cat;} span.ct {mso-style-name:ct;} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:Consolas;} p.attach, li.attach, div.attach {mso-style-name:attach; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:9.0pt; font-family:"Arial","sans-serif";} p.bold, li.bold, div.bold {mso-style-name:bold; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:10.0pt; font-family:"Arial","sans-serif"; font-weight:bold;} p.green, li.green, div.green {mso-style-name:green; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; color:#628C2A;} p.replbq, li.replbq, div.replbq {mso-style-name:replbq; margin:3.0pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad, li.ad, div.ad {mso-style-name:ad; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline, li.underline, div.underline {mso-style-name:underline; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.yshortcuts {mso-style-name:yshortcuts;} p.ad1, li.ad1, div.ad1 {mso-style-name:ad1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad2, li.ad2, div.ad2 {mso-style-name:ad2; mso-margin-top-alt:auto; margin-right:0in; margin-bottom:7.5pt; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline1, li.underline1, div.underline1 {mso-style-name:underline1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; text-decoration:underline;} span.yshortcuts1 {mso-style-name:yshortcuts1; font-family:"Verdana","sans-serif"; font-weight:bold;} span.yshortcuts2 {mso-style-name:yshortcuts2; font-family:"Verdana","sans-serif"; font-weight:normal;} span.EmailStyle36 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:2074961704; mso-list-template-ids:-2090980948;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:"Courier New"; mso-bidi-font-family:"Times New Roman";} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> </head> <body bgcolor="white" lang="EN-US" link="blue" vlink="purple"> <div class="WordSection1"> <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">These features are reserved for DBA module only.<o:p></o:p></span></p> <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"> <p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> [email protected] [mailto:[email protected]] <b>On Behalf Of </b>ss052111<br> <b>Sent:</b> Tuesday, April 23, 2013 2:30 PM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> [toad] Re: Schema Comparison Nusiances 11.6.1<o:p></o:p></span></p> </div> </div> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"> <o:p></o:p></p> <div id="ygrp-mlmsg"> <div id="ygrp-msg"> <div id="ygrp-text"> <p style="margin-bottom:12.0pt">Another Compare Schemas problem. I'm running v11.6.1.6.<br> <br> I've done my compare, and I'd like to run the sync script. I see my script, but the buttons "Save", "Move Script to Editor", "Move Script to Editor and Run Now", and "Schedule Script" are all grayed out. It seems the only option I have is to print the script. If I try to select and copy the script, it does not go to the clipboard.<br> <br> The only way I've had any success at all is to print the script to CutePDF, but even then the script has line numbers, headers, etc. which prevent it from being too much use.<br> <br> I also tried setting the Sync Script output file on the "Define Target Schema and Output" window. I was excited to see my output file until I realized that Toad only wrote the header information, but none of the actual DDL.<br> <br> Has anyone else seen this behavior?<br> <br> Sean<br> <br> --- In <a href="mailto:toad%40yahoogroups.com">[email protected]</a>, John Dorlon <<a href="mailto:john.dorlon@...">john.dorlon@...</a>> wrote:<br> ><br> > I see that. Also fixed for next beta.<br> > <br> > Thanks.<br> > <br> > <br> > From: <a href="mailto:toad%40yahoogroups.com">[email protected]</a> [mailto:<a href="mailto:toad%40yahoogroups.com">[email protected]</a>] On Behalf Of chuckoneal99<br> > Sent: Monday, December 31, 2012 9:40 AM<br> > To: <a href="mailto:toad%40yahoogroups.com">[email protected]</a><br> > Subject: [toad] Re: Schema Comparison Nusiances 11.6.1<br> > <br> > <br> > <br> > I've noticed another one while changing sources and targets multiple times in the same schema comparison window. After a new source connection is defined the schema drop down does not refresh. It does refresh the schemas after picking the new connection again from the drop down list. Shouldn't the schema dropdown refresh when the connection is established? I'm not connecting as a schema owner if that matters.<br> > <br> > --- In <a href="mailto:toad%40yahoogroups.com">[email protected]</a><mailto:toad%40yahoogroups.com>, John Dorlon <<a href="mailto:john.dorlon@%3cmailto:john.dorlon@">john.dorlon@<mailto:john.dorlon@</a>>> wrote:<br> > ><br> > > Thanks Chuck. Both are fixed in the next beta.<br> > ><br> > ><br> > > From: <a href="mailto:toad%40yahoogroups.com">[email protected]</a><mailto:toad%40yahoogroups.com> [mailto:<a href="mailto:toad%40yahoogroups.com">[email protected]</a><mailto:toad%40yahoogroups.com>] On Behalf Of chuckoneal99<br> > > Sent: Sunday, December 30, 2012 4:09 PM<br> > > To: <a href="mailto:toad%40yahoogroups.com">[email protected]</a><mailto:toad%40yahoogroups.com><br> > > Subject: [toad] Schema Comparison Nusiances 11.6.1<br> > ><br> > ><br> > ><br> > > I'm in the middle of comparing ~25 schemas for first of 4 separate environments to a baseline for the first of many times and want to point out a few annoyances in 11.6.1.<br> > ><br> > > 1. Select source schema definition file, click in and define target, OK to return to Options and the source is blanked.<br> > > 2. The ellipse always open User Files. Two days later I have the revelation of copying all of the SDXML files there, but it would be nice if it could remember the prior paths.<br> > ><br> > > My goal is to make this a repeatable process using the Automation Designer. I'm thinking I need generic schema specific source/target.SDXML files vs. the default SID/timespamped file names. Same goes for the sync scripts and report files.<br> > ><br> > > This is an incredibly powerful combination of tools I feel is somewhat under-advertised. Who doesn't, or better, who shouldn't be routinely comparing development/test environments to pre-established baselines.<br> > ><br> ><o:p></o:p></p> </div> <div> <p class="MsoNormal"><span style="color:white"><o:p></o:p></span></p> </div> </div> <!-- |**|begin egp html banner|**| --> <br> <br> <!-- |**|end egp html banner|**| --> <div width="1" style="color: white; clear: both;"/>__._,_.___</div> <!-- Start Recommendations --> <!-- End Recommendations --> <!-- |**|begin egp html banner|**| --> <img src="http://geo.yahoo.com/serv?s=97476590/grpId=1103546/grpspId=1705115368/msgId=58479/stime=1366746631" width="1" height="1"> <br> <!-- |**|end egp html banner|**| --> <!-- |**|begin egp html banner|**| --> <br> <div style="font-family: verdana; font-size: 77%; border-top: 1px solid #666; padding: 5px 0;" > Your email settings: Individual Email|Traditional <br> <a href="http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmaDUxa3ZjBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNjY3NDY2MzE-">Change settings via the Web</a> (Yahoo! ID required) <br> Change settings via email: <a href="mailto:[email protected]?subject=Email Delivery: Digest">Switch delivery to Daily Digest</a> | <a href = "mailto:[email protected]?subject=Change Delivery Format: Fully Featured">Switch to Fully Featured</a> <br> <a href="http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkYmk0MWw4BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzY2NzQ2NjMx"> Visit Your Group </a> | <a href="http://docs.yahoo.com/info/terms/"> Yahoo! Groups Terms of Use </a> | <a href="mailto:[email protected]?subject=Unsubscribe"> Unsubscribe </a> <br> </div> <br> <!-- |**|end egp html banner|**| --> <div style="color: white; clear: both;"/>__,_._,___</div> </body> </html> --_000_4120B436C765EC43A31CC3E2A13D36A62643736DALVMBXW02prodqu_--