defaria.com/blogs/Status/2006/04/more-fun-with-s.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="Attempting to transfer databases using MS Access OK, trying this methodology: Used installutil copyschemarepo command to copy schema.db -&gt; schema.mdb Moved schema.mdb to new server Used installutil copyuserdb command to copy salira_test.db -&gt; test.db. Moved test.db to new server Tried...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>More fun with SQL ANYWHERE - 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/2006/04/more-fun-with-s.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/2006/04/build-bugs-test.html" title="Build bugs, Test suite still not runing nightly">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2006/04/production-user.html" title="Production User Database Migrated">
  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="More fun with SQL ANYWHERE">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2006/04/more-fun-with-s.html">
  26     <meta property="og:description" content="Attempting to transfer databases using MS Access OK, trying this methodology: Used installutil copyschemarepo command to copy schema.db -&amp;gt; schema.mdb Moved schema.mdb to new server Used installutil copyuserdb command to copy salira_test.db -&amp;gt; test.db. Moved test.db to new server Tried...">
  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="Attempting to transfer databases using MS Access OK, trying this methodology: Used installutil copyschemarepo command to copy schema.db -&gt; schema.mdb Moved schema.mdb to new server Used installutil copyuserdb command to copy salira_test.db -&gt; test.db. Moved test.db to new server Tried...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2006/04/more-fun-with-s.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">More fun with SQL ANYWHERE</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1803" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">More fun with SQL ANYWHERE</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2006-04-12T22:50:07-08:00" itemprop="datePublished">April 12, 2006</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/salira/">Salira</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <h3>Attempting to transfer databases using MS Access</h3>
  85
  86 <p>OK, trying this methodology:</p>
  87
  88 <ul>
  89   <li>Used installutil copyschemarepo command to copy schema.db -&gt;
  90 schema.mdb</li>
  91   <li>Moved schema.mdb to new server</li>
  92   <li>Used installutil copyuserdb command to copy salira_test.db -&gt;
  93 test.db.</li>
  94   <li>Moved test.db to new server</li>
  95   <li>Tried several times to use installutil command to copy
  96 salira_bugs.db (the production database) -&gt; bugs2.db. System aborted
  97 several times. Not sure if this is due to bad disk blocks or not. This
  98 is a major problem as this is the data we care about.</li>
  99 </ul>
 100
 101 <p>Back on the new server:</p>
 102
 103 <ul>
 104   <li>If I do Connection: New and point to the schema.mdb file it wants
 105 to overwrite it! Instead I did File: Import Profile of a profile of the
 106 old databases. Of course these say SQL_ANYWHERE. I change this to
 107 MS_ACCESS and point to the schema.mdb file and this seems to work.</li>
 108   <li>Attempt to do Schema Repository: Move. In doing so I set the
 109 Physical Database Name by browsing to the folder via the ellipsis
 110 button. This leaves me with D:\Clearquest\schema.db. Clicking on Finish
 111 give ms:<br>
 112     <blockquote>The filename you have specified is not a Share. If
 113 other users will need access to this database, you should browse
 114 through "Network Neighborhood" to place is in a share. Continue with
 115 this name?<br>
 116     </blockquote>
 117 I select No because I do want other users to be able to access this
 118 database. Next I change the D:\Clearquest\salira.db -&gt;
 119 \\sons-sc-cc\Clearquest\schema.db and click Finish. At this point I get
 120 a error dialog stating that it was "Unable to connect to the database
 121 server". After much scratching of the head I realize that I should use
 122 D:\Clearquest\schema.db, ignore the warning, then go back in and set
 123 the Physical Database Name to \\sons-sc-cc\Clearquest\schema.db.<br>
 124     <br>
 125 Oh, a side issue: After failing using a Physical Database Name of
 126 \\sons-sc-cc\Clearquest\schema.db the Rational Clearquest Maintenance
 127 Tool still creates a schema.db file. If you go Back and correct the
 128 Physical Database Name to a local path and click Finish you'll get a
 129 database I/O error. Turns out you have to remove this schema.db file
 130 first. These two (what else could I call them but) BUGS caused me to
 131 lose many hours of sleep.<br>
 132     <br>
 133 Managed to move the schema.mdb -&gt; schema.db.</li>
 134   <li>Switching to the Clearquest Designer now to Database: Update User
 135 Database Properties. As I only have the test.mdb file to convert I
 136 change the user database properties for the test database.</li>
 137   <li>Now I select Database: Move User Database to move the test user
 138 database to SQL_ANYWHERE</li>
 139 </ul>
 140
 141 <p>At this point I'd like to run Clearquest Designer and do Test Work so I
 142 can at at least verify that I can access the converted to SQL_ANYWHERE
 143 test.db. Unfortunately there is a checked out version of the schema in
 144 the schema database that I copied over and I'm not the owner of that
 145 checked out schema. And I can't login as that user.</p>
 146
 147 <p>By chance I tried Schema Repository: Upgrade: Selected connection in
 148 the Clearquest Maintenance Tool and in stepping through those dialog
 149 boxes it say "The schema repository that you want to upgrade has
 150 checked-out schemas. If you continue the upgrade process, the checked
 151 out schema versions cannot be upgraded and will be deleted from the
 152 system". I continue onward and manage to "upgrade" the schema and test
 153 database. I proceed into Clearquest Designer and manage to Test Work
 154 and viola! I got it up. I am nothing if not tenacious!</p>
 155
 156 <p><b>Total Time:</b> 2 hours</p>
 157
 158                 </div>
 159                 <nav class="page-navigation entry-navigation pagination content-nav">
 160                   <ul class="page-navigation-list">
 161
 162                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2006/04/build-bugs-test.html" title="Build bugs, Test suite still not runing nightly">Previous entry</a></li>
 163
 164
 165                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2006/04/production-user.html" title="Production User Database Migrated">Next entry</a></li>
 166
 167                   </ul>
 168                 </nav>
 169                 <!--
 170 <aside id="zenback" class="zenback feedback">
 171   Please paste Zenback script code here.
 172 </aside>
 173 -->
 174
 175
 176               </article>
 177             </div>
 178             <aside class="widgets related" role="complementary">
 179               <nav class="widget-search widget">
 180   <div class="widget-content">
 181     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 182       <div>
 183         <input type="text" name="search" value="" placeholder="Search...">
 184
 185         <input type="hidden" name="IncludeBlogs" value="8">
 186
 187         <input type="hidden" name="limit" value="20">
 188         <button type="submit" name="button">
 189           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 190         </button>
 191       </div>
 192     </form>
 193   </div>
 194 </nav>
 195 <nav class="widget-archive-category widget">
 196   <h3 class="widget-header">Categories</h3>
 197   <div class="widget-content">
 198
 199
 200     <ul class="widget-list">
 201
 202
 203       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 204
 205
 206       </li>
 207
 208
 209
 210
 211       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 212
 213
 214       </li>
 215
 216
 217
 218
 219       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 220
 221
 222       </li>
 223
 224
 225
 226
 227       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 228
 229
 230       </li>
 231
 232
 233
 234
 235       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 236
 237
 238       </li>
 239
 240
 241
 242
 243       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 244
 245
 246       </li>
 247
 248
 249
 250
 251       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 252
 253
 254       </li>
 255
 256
 257
 258
 259       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 260
 261
 262       </li>
 263
 264
 265
 266
 267       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 268
 269
 270       </li>
 271
 272
 273
 274
 275       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 276
 277
 278       </li>
 279
 280
 281
 282
 283       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 284
 285
 286       </li>
 287
 288
 289
 290
 291       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 292
 293
 294       </li>
 295
 296     </ul>
 297
 298
 299   </div>
 300 </nav>
 301
 302
 303 <nav class="widget-archive-dropdown widget">
 304   <h3 class="widget-header">Archives</h3>
 305   <div class="widget-content">
 306     <select>
 307       <option>Select a Month...</option>
 308
 309       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 310
 311
 312
 313       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 314
 315
 316
 317       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 318
 319
 320
 321       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 322
 323
 324
 325       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 326
 327
 328
 329       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 330
 331
 332
 333       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 334
 335
 336
 337       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 338
 339
 340
 341       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 342
 343
 344
 345       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 346
 347
 348
 349       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 350
 351
 352
 353       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 354
 355
 356
 357       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 358
 359
 360
 361       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 362
 363
 364
 365       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 366
 367
 368
 369       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 370
 371
 372
 373       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 374
 375
 376
 377       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 378
 379
 380
 381       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 382
 383
 384
 385       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 386
 387
 388
 389       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 390
 391
 392
 393       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 394
 395
 396
 397       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 398
 399
 400
 401       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 402
 403
 404
 405       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 406
 407
 408
 409       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 410
 411
 412
 413       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 414
 415
 416
 417       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 418
 419
 420
 421       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 422
 423
 424
 425       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 426
 427
 428
 429       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 430
 431
 432
 433       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 434
 435
 436
 437       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 438
 439
 440
 441       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 442
 443
 444
 445       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 446
 447
 448
 449       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 450
 451
 452
 453       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 454
 455
 456
 457       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 458
 459
 460
 461       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 462
 463
 464
 465       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 466
 467
 468
 469       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 470
 471
 472
 473       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 474
 475
 476
 477       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 478
 479
 480
 481       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 482
 483
 484
 485       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 486
 487
 488
 489       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 490
 491
 492
 493       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 494
 495
 496
 497       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 498
 499
 500
 501       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 502
 503
 504
 505       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 506
 507
 508
 509       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 510
 511
 512
 513       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 514
 515
 516
 517       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 518
 519
 520
 521       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 522
 523
 524
 525       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 526
 527
 528
 529       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 530
 531
 532
 533       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 534
 535
 536
 537       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 538
 539
 540
 541       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 542
 543
 544
 545       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 546
 547
 548
 549       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 550
 551
 552
 553       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 554
 555
 556
 557       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 558
 559
 560
 561       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 562
 563
 564
 565       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 566
 567
 568
 569       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 570
 571
 572
 573       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 574
 575
 576
 577       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 578
 579
 580
 581       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 582
 583
 584
 585       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 586
 587
 588
 589       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 590
 591
 592
 593       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 594
 595     </select>
 596   </div>
 597 </nav>
 598
 599
 600
 601 <div class="widget-syndication widget section">
 602   <div class="widget-content">
 603     <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>
 604
 605   </div>
 606 </div>
 607
 608             </aside>
 609           </div>
 610         </div>
 611         <footer id="footer" role="contentinfo">
 612           <div id="footer-inner">
 613             <div id="footer-content">
 614   <nav role="navigation">
 615           <ul>
 616             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 617
 618
 619           </ul>
 620         </nav>
 621
 622   <p class="license">&copy; Copyright 2016.</p>
 623   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 624 </div>
 625           </div>
 626         </footer>
 627       </div>
 628     </div>
 629     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 630     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 631   </body>
 632 </html>