defaria.com/blogs/Status/2012/08/creating-develo.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" When you have multiple Clearquest Designers you quickly realize that you cannot easily do parallel development of the schema. The best way to do this is to work through a development schema repository and to create development schemas for...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>Creating Development Schema Repositories - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2012/08/creating-develo.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2012/08/eliminating-per.html" title="Eliminating Perl Syntactic Sugar">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2012/08/creating-a-deve.html" title="Creating a Development Schema">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="Creating Development Schema Repositories">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2012/08/creating-develo.html">
  26     <meta property="og:description" content=" When you have multiple Clearquest Designers you quickly realize that you cannot easily do parallel development of the schema. The best way to do this is to work through a development schema repository and to create development schemas for...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" When you have multiple Clearquest Designers you quickly realize that you cannot easily do parallel development of the schema. The best way to do this is to work through a development schema repository and to create development schemas for...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2012/08/creating-develo.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">Creating Development Schema Repositories</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1975" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">Creating Development Schema Repositories</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2012-08-28T14:41:42-08:00" itemprop="datePublished">August 28, 2012</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/broadcom/">Broadcom</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                               <p>When you have multiple Clearquest Designers you quickly realize that you cannot easily do parallel development of the schema. The best way to do this is to work through a development schema repository and to create development schemas for each schema designer. To create a development schema repository you should first create an empty database for Clearquest to work in. You can create an empty database by following the instructions for&nbsp;<span class="nobr"><a href="http://confluence.broadcom.com/display/MWGMPSSCM/Creating+a+Development+Schema#CreatingaDevelopmentSchema-CreatingaTestDatbase" class="external-link" rel="nofollow">Creating a Test Database</a>. Next you must use the Clearquest Maintenance Tool to create a new Schema Repository:</p>
  85
  86 <ul>
  87   <li>Start the Clearquest Maintenance Tool</li>
  88   <li>Select <b>Schema Respository: Create</b></li>
  89   <li>The Maintenance Tool then asks you to fill out information regarding the location of your schema database. Fill in information about the database server and Administrator Name and password. Do not create a sample database at this time. The Clearquest Maintenance tool will take some time to set up the new schema repository.</li>
  90 </ul>
  91
  92 <h3><a name="CreatingDevelopmentSchemaRepositories-ExportingaCQProfile.iniforthisnewDevelopmentSchemaRepository"></a>Exporting a CQProfile.ini for this new Development Schema Repository</h3>
  93
  94 <p>In order to see this new development schema repository you should export the schema repository from the Clearquest&nbsp;Maintenance&nbsp;Tool. This exported cqprofile.ini can be shared with out Schema Developers who would import the .ini file into their environment using the Clearquest Maintenance Tool. You export the cqprofile.ini by selecting&nbsp;<b>File: Export Profile</b>. You need only select the new repository you created.</p>
  95
  96 <p><img src="images/Export cqprofile.png"></p>
  97
  98 <p>Click on the "..." button to select where to store the .ini file and what it's name will be - I used C:\Cygwin\tmp\MPSDev.ini and click&nbsp;<b>Finish</b>. This file can be passed to your fellow Schema Developers.</p>
  99
 100 <h3><a name="CreatingDevelopmentSchemaRepositories-ImportingUsers"></a>Importing Users</h3>
 101
 102 <p>Your new development schema repo has no users in it except a default set of users including the "admin" user (with no password). Run the User Administration tool on production (MCBU) and export all of the users. Run the User Administration tool again on the new development schema repo (e.g. MPSDev) and import the users.</p>
 103
 104 <h3><a name="CreatingDevelopmentSchemaRepositories-CleanupUnnecessarySchemas"></a>Clean up Unnecessary Schemas</h3>
 105
 106 <p>Now's a good time to remove additional default schemas in your development schema repo like Common, DefectTracking, Enterprise, etc. You cannot delete the Blank schema.</p>
 107
 108 <h3><a name="CreatingDevelopmentSchemaRepositories-SeedingtheDevelopmentSchemaRepowiththeLatestVersionfromProduction"></a>Seeding the Development Schema Repo with the Latest Version from Production</h3>
 109
 110 <p>One trick to seed your new development schema repo with a recent version of the production schema is to create a new development schema in the production schema repo based off of the latest version of the production schema. Then export that whole schema of the <b>new</b> development schema and import it into the new development schema repo. You will only have the history of the latest version of the schema but that's OK for development purpose. Make sure you specify an appropriate Schema Name and Comment when you export the schema from production:</p>
 111
 112 <p><img src="images/New Schema.png"></p>
 113
 114 <p><b>Note:</b>&nbsp;We are giving this schema the name MPSDev because that's what we want it to be called in the new development schema repo. Also, the comment is appropriate when we will be looking at it in the MPSDev development schema repo.</p>
 115
 116 <p>Do not associate a database with this schema, there's no reason. We don't care as we are only using this to exportschema from production &#45;&gt; development schema repo. We'll create databases there. We don't need to check out this schema either.</p>
 117
 118 <h4><a name="CreatingDevelopmentSchemaRepositories-ExportingtheSchemafromProduction"></a>Exporting the Schema from Production</h4>
 119
 120 <p>We assume you have created a new development schema in the production schema repo based off of the tip of the production database. You need to export that with:</p>
 121
 122 <div class="code" >$ cqload exportschema -dbset MCBU admin &lt;password&gt; &lt;schemaname&gt; &lt;path to &lt;schemaname&gt;.full.schema&gt;]]>
 123 </div>
 124
 125 <p>Where &lt;schemaname&gt; is the name of the development schema name you created in the production schema repo</p>
 126
 127 <h4><a name="CreatingDevelopmentSchemaRepositories-ImportingtheSchemaintotheDevelopmentSchemaRepo"></a>Importing the Schema into the Development Schema Repo</h4>
 128
 129 <p>Next we import this full.schema of only the tip of production to seed a development schema in the development schema repo.</p>
 130
 131 <p><div class="code">$ cqload importschema -dbset MPSDev admin &lt;password&gt; &lt;path to &lt;schemaname&gt;.full.schema&gt;
 132 *********************************************************
 133 Starting importschema
 134 *********************************************************
 135
 136 CRMMD1264E The import file ".\MPSDev.full.schema" is invalid:
 137 CRMMD1422E The schema requires the following package(s), which is(are) not currently installed in the database...
 138     revision '2.1' of package 'EmailPlus'
 139     revision '1.2' of package 'Resolution'
 140     revision '2.1' of package 'Attachments'.
 141
 142 *********************************************************
 143 ERROR: importschema FAILED!
 144 *********************************************************
 145 </div>
 146
 147 <p>Oops! We need to import these packages into our new schema. Right click on your new development schema repo in Clearquest Designer and select <b>Install Package</b>. Expand the EmailPlus and select 2.1 to install that. Repeat this for Resolution and Attachments. Repeat the cqload importschema.</p>
 148
 149 <h4><a name="CreatingDevelopmentSchemaRepositories-RemoveOldSchemainProductionRepo"></a>Remove Old Schema in Production Repo</h4>
 150
 151 <p>You can remove the schema you created above in the Production repo as it is no longer needed.</p>
 152
 153 <h3><a name="CreatingDevelopmentSchemaRepositories-CreateDevSchemas"></a>Create Dev Schemas</h3>
 154
 155 <p>You are now free to create development schemas in the new development schema repo as described&nbsp;<a href="/display/MWGMPSSCM/Creating+a+Development+Schema" title="Creating a Development Schema">Creating a Development Schema</a>&nbsp;as well as test databases and <a href="/display/MWGMPSSCM/Seeding+a+Test+Database" title="Seeding a Test Database">seeding them</a>.</p>
 156
 157                 </div>
 158                 <nav class="page-navigation entry-navigation pagination content-nav">
 159                   <ul class="page-navigation-list">
 160
 161                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2012/08/eliminating-per.html" title="Eliminating Perl Syntactic Sugar">Previous entry</a></li>
 162
 163
 164                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2012/08/creating-a-deve.html" title="Creating a Development Schema">Next entry</a></li>
 165
 166                   </ul>
 167                 </nav>
 168                 <!--
 169 <aside id="zenback" class="zenback feedback">
 170   Please paste Zenback script code here.
 171 </aside>
 172 -->
 173
 174
 175               </article>
 176             </div>
 177             <aside class="widgets related" role="complementary">
 178               <nav class="widget-search widget">
 179   <div class="widget-content">
 180     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 181       <div>
 182         <input type="text" name="search" value="" placeholder="Search...">
 183
 184         <input type="hidden" name="IncludeBlogs" value="8">
 185
 186         <input type="hidden" name="limit" value="20">
 187         <button type="submit" name="button">
 188           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 189         </button>
 190       </div>
 191     </form>
 192   </div>
 193 </nav>
 194 <nav class="widget-archive-category widget">
 195   <h3 class="widget-header">Categories</h3>
 196   <div class="widget-content">
 197
 198
 199     <ul class="widget-list">
 200
 201
 202       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 203
 204
 205       </li>
 206
 207
 208
 209
 210       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 211
 212
 213       </li>
 214
 215
 216
 217
 218       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 219
 220
 221       </li>
 222
 223
 224
 225
 226       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 227
 228
 229       </li>
 230
 231
 232
 233
 234       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 235
 236
 237       </li>
 238
 239
 240
 241
 242       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 243
 244
 245       </li>
 246
 247
 248
 249
 250       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 251
 252
 253       </li>
 254
 255
 256
 257
 258       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 259
 260
 261       </li>
 262
 263
 264
 265
 266       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 267
 268
 269       </li>
 270
 271
 272
 273
 274       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 275
 276
 277       </li>
 278
 279
 280
 281
 282       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 283
 284
 285       </li>
 286
 287
 288
 289
 290       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 291
 292
 293       </li>
 294
 295     </ul>
 296
 297
 298   </div>
 299 </nav>
 300
 301
 302 <nav class="widget-archive-dropdown widget">
 303   <h3 class="widget-header">Archives</h3>
 304   <div class="widget-content">
 305     <select>
 306       <option>Select a Month...</option>
 307
 308       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 309
 310
 311
 312       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 313
 314
 315
 316       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 317
 318
 319
 320       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 321
 322
 323
 324       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 561
 562
 563
 564       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 565
 566
 567
 568       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 569
 570
 571
 572       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 573
 574
 575
 576       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 577
 578
 579
 580       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 581
 582
 583
 584       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 585
 586
 587
 588       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 589
 590
 591
 592       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 593
 594     </select>
 595   </div>
 596 </nav>
 597
 598
 599
 600 <div class="widget-syndication widget section">
 601   <div class="widget-content">
 602     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 603
 604   </div>
 605 </div>
 606
 607             </aside>
 608           </div>
 609         </div>
 610         <footer id="footer" role="contentinfo">
 611           <div id="footer-inner">
 612             <div id="footer-content">
 613   <nav role="navigation">
 614           <ul>
 615             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 616
 617
 618           </ul>
 619         </nav>
 620
 621   <p class="license">&copy; Copyright 2016.</p>
 622   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 623 </div>
 624           </div>
 625         </footer>
 626       </div>
 627     </div>
 628     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 629     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 630   </body>
 631 </html>