defaria.com/blogs/Status/archives/000456.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml" />
  11
  12    <title>Status for Andrew DeFaria: enable_ldap/Another PQA Merge</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/000455.html" title="Most PQA Issues resolved..." />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000457.html" title="AddListMember" />
  17
  18
  19
  20
  21
  22    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  23 </head>
  24 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  25    <div id="container">
  26       <div id="container-inner" class="pkg">
  27
  28          <div id="banner">
  29             <div id="banner-inner" class="pkg">
  30                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  31                <h2 id="banner-description">Searchable status reports and work log</h2>
  32             </div>
  33          </div>
  34
  35          <div id="pagebody">
  36             <div id="pagebody-inner" class="pkg">
  37                <div id="alpha">
  38                   <div id="alpha-inner" class="pkg">
  39
  40                      <p class="content-nav">
  41                         <a href="http://defaria.com/blogs/Status/archives/000455.html">&laquo; Most PQA Issues resolved...</a> |
  42                         <a href="http://defaria.com/blogs/Status/">Main</a>
  43                         | <a href="http://defaria.com/blogs/Status/archives/000457.html">AddListMember &raquo;</a>
  44                      </p>
  45
  46                      <a id="a000456"></a>
  47                      <div class="entry" id="entry-456">
  48                         <h3 class="entry-header">enable_ldap/Another PQA Merge</h3>
  49                         <div class="entry-content">
  50                            <div class="entry-body">
  51                               <ul>
  52   <li>Wrote and enable_ldap Perl script</li>
  53
  54   <li>Vinh Ton has provided me with yet another schema and corresponding databases</li>
  55 </ul>
  56                            </div>
  57                            <div id="more" class="entry-more">
  58                               <h2>Another Merge</h2>
  59
  60 <p>Performing yet another merge so I will once again document the steps I take:</p>
  61
  62 <ul>
  63   <li>Restored the databases CQSchema03, CQ_Controller_Test and CQ_Controller_Prod. Doing so wipes out the old data</li>
  64
  65   <li>When importing you must go into the CQSchema03 tables for master_dbs and change the server to p4test. Otherwise you will be effecting the data on the other server!</li>
  66
  67   <li>Enter Clearquest Designer and mark the following fields as optional:</li>
  68
  69     <ul>
  70       <li>Submitter</li>
  71
  72       <li>Submit_Date</li>
  73
  74       <li>Audit_Log</li>
  75
  76       <li>old_id</li>
  77    </ul>
  78
  79   <li>Change commitmentLevel_Value_Changed hook to simply return</li>
  80
  81   <li>Test Work, Check in Schema and Upgrade Database</li>
  82
  83   <li>Import OEMUsers.cqu and Users.cqu</li>
  84
  85   <li>Upgrade Database</li>
  86
  87   <li>Run pqamerge</li>
  88
  89   <li>Test</li>
  90
  91   <li>Reverse the schema changes performed above and apply the changes</li>
  92
  93   <li>Backup new CQSchema03, CQ_Controller_Test and CQ_Controller_Prod</li>
  94 </ul>
  95
  96 <p>Use the following for a Check in Comment:</p>
  97
  98 <blockquote>
  99   <p>Changing Submitter, Submit_Date, Audit_Log and old_id to be optional for data conversion</p>
 100
 101   <p>Also changed commitmentLevel_ValueChanged hook to return before sending email.</p>
 102 </blockquote>
 103                            </div>
 104                         </div>
 105                         <p class="entry-footer">
 106                            <span class="post-footers">Posted by  on October 20, 2005  6:19 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000456.html">Permalink</a>
 107                         </p>
 108                      </div>
 109
 110
 111
 112
 113                   </div>
 114                </div>
 115             </div>
 116          </div>
 117       </div>
 118    </div>
 119 </body>
 120 </html>