2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content="Creating a dev schema is not that difficult. Note you can create a dev schema in the production schema repo or in a dev schema repo. The later is a just a bit safer as it is a bit more...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>Creating a Development Schema - 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-a-deve.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
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>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2012/08/creating-develo.html" title="Creating Development Schema Repositories">
20 <link rel="next" href="http://defaria.com/blogs/Status/2012/09/shebang-and-scr.html" title="Shebang and script interpreters">
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 a Development Schema">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2012/08/creating-a-deve.html">
26 <meta property="og:description" content="Creating a dev schema is not that difficult. Note you can create a dev schema in the production schema repo or in a dev schema repo. The later is a just a bit safer as it is a bit more...">
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">
30 <meta itemprop="description" content="Creating a dev schema is not that difficult. Note you can create a dev schema in the production schema repo or in a dev schema repo. The later is a just a bit safer as it is a bit more...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2012/08/creating-a-deve.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
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 a Development Schema</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1976" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">Creating a Development Schema</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-29T21:08:12-08:00" itemprop="datePublished">August 29, 2012</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/broadcom/">Broadcom</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
84 <p>Creating a dev schema is not that difficult. Note you can create a dev schema in the production schema repo or in a dev schema repo. The later is a just a bit safer as it is a bit more isolated.</p>
86 <p>To create a dev schema from the CQ Designer, right click on the schema repo and select <b>New: Schema</b>. We are creating a new schema by basing it off of an existing schema. Expand the + sign and select the version that you wish to base your new schema off of. Right now there is only Version 1. Select next and name your schema. I suggest that you use your username (e.g. adefaria) indicating that we are the owner of this dev schema. Enter comments if you like and then <b>Finish</b>.</p>
88 <p>After the schema is created it will ask you if you want to associate this with a database. You could select <b>Yes</b> and then go though naming your database and connecting it to an existing user database but chances are you don't have one of those yet. So select <b>No</b> for now. You now have a development schema.</p>
90 <h3>Creating a Test Database</h3>
92 <p>You must create an empty database on the database server. Use RDP to get a remote desktop there and run the SQL Server Management Studio and connect to the database server engine.</p>
94 <p>Next right click on databases and select New Database. Name your database. The convention for test databases is <schemaname>_<id>. For our personal test databases again I'd suggest using your user ID so I will create <schemaname>_adefaria for me.</p>
96 <h3>Setting the db_owner and schema owner</h3>
98 <p>In MSSQL we need to set the dbowner and the schema for this new database. Expand the folder tree (+) on your newly created database (MobDev_adefaria) then right click on Security and select New: User. Type <dbadmin> in the User Name edit box and then select and copy this string. We'll need it several times more in this process. Paste this into the Login name and Default Schema and then toggle on db_owner in both the Schemas owned by this user and Database role membership boxes then select OK.</p>
100 <p>Next right click on Security again and select <b>New: Schema</b>. Paste <dbadmin> into Schema Name and Schema Owner and click OK.</p>
102 <p>Now you have an empty database that you can associate with your schema.</p>
104 <h3>Associating your new test database with your dev schema</h3>
106 <p>Go back to CQ Designer and right click on your development schema again and select <b>Show: User Databases</b>. You should see a list of databases. Right click on an empty area and select <b>Create Database</b>. Seems odd to call it create database when the database has already been created - it really means "take this schema and it's definition of what should be in the user database and apply that definition/schema to my newly created empty database".</p>
108 <p>Give this database a Logical Database Name. Alas we only have 5 characters. I just use my initials - apd - short and simple. Add comments if you like. We use MSSQL for the database vendor. Then toggle Database Type to Test Database. We already have a production database in our dev schema repo then select next.</p>
110 <p>Now we fill in Physical Database Name with the name of the database (<schemaname>_adefaria) and the Database Server . Then paste that <dbadmin> into Administrator User and Administrator Password (See I told you you'd need it!) then Next and Next again.</p>
112 <p>Now we need to expand the adefaria (your dev schema) and select which version you want this new test database to start with. Select Version 1 and Finish.</p>
114 <p>Clearquest Designer now goes out and creates all the necessary tables and transfers all of the necessary data, hook scripts, etc. from Version 1 of the dev schema adefaria into your database. Get coffee...</p>
116 <p>After the database is created follow the steps at Seeding a test database to seed your test database with some test data.</p>
119 <nav class="page-navigation entry-navigation pagination content-nav">
120 <ul class="page-navigation-list">
122 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2012/08/creating-develo.html" title="Creating Development Schema Repositories">Previous entry</a></li>
125 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2012/09/shebang-and-scr.html" title="Shebang and script interpreters">Next entry</a></li>
130 <aside id="zenback" class="zenback feedback">
131 Please paste Zenback script code here.
138 <aside class="widgets related" role="complementary">
139 <nav class="widget-search widget">
140 <div class="widget-content">
141 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
143 <input type="text" name="search" value="" placeholder="Search...">
145 <input type="hidden" name="IncludeBlogs" value="8">
147 <input type="hidden" name="limit" value="20">
148 <button type="submit" name="button">
149 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
155 <nav class="widget-archive-category widget">
156 <h3 class="widget-header">Categories</h3>
157 <div class="widget-content">
160 <ul class="widget-list">
163 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
171 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
243 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
251 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
263 <nav class="widget-archive-dropdown widget">
264 <h3 class="widget-header">Archives</h3>
265 <div class="widget-content">
267 <option>Select a Month...</option>
269 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
273 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
277 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
281 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
285 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
289 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
293 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
297 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
301 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
305 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
309 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
313 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
317 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
321 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
325 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
329 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
333 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
337 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
341 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
345 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
349 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
353 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
357 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
361 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
365 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
369 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
373 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
377 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
381 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
385 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
389 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
417 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
421 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
425 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
429 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
433 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
461 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
465 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
469 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
473 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
477 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
509 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
513 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
517 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
521 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
525 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
549 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
553 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
561 <div class="widget-syndication widget section">
562 <div class="widget-content">
563 <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>
571 <footer id="footer" role="contentinfo">
572 <div id="footer-inner">
573 <div id="footer-content">
574 <nav role="navigation">
576 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
582 <p class="license">© Copyright 2016.</p>
583 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
589 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
590 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>