During the normal course of ClearQuest development, I often want to create a new development database from a production backup and have it available from the same schema (i.e. I don’t want to create a separate schema database from a production snapshot as well). Because you can’t have two user databases registered to a schema with the same logical database name, you need to be able to change the logical name of the newly created development database in some way. For example, if my production database is called LON, I want to call my new development instance LOND1 (I use the convention ‘D’ to indicate a development database; other conventions: ‘A’ for acceptance/UAT, and ‘S’ for staging). This blog assumes your new development database has been created and subsequently primed using production data (see my other blog posts on how to accomplish this).
Continue reading ‘Changing the logical name of a ClearQuest user database.’
I’ve done some pretty masochistic ClearQuest database migrations in my time. By masochistic I mean that instead of using the Rational recommended approach for a database migration (I don’t even know what that is. Fiddling around with the import/export tool? No thanks!), I’ll write routines in Transact/SQL or PL/SQL (SQL Server and Oracle’s procedural language extensions to SQL, respectively) to manually coerce the data into shape. Why? Tends to be more fun. It’s a lot faster than any other approach, too.
Continue reading ‘Create your very own ClearQuest dbids…’
I was going through old SQL snippets I’ve collected the other day and came across this little chestnut that counts the lines of hook code in a ClearQuest database. Horrendously useless in the grand scheme of things, unless you enjoy distracting yourself from real work with useless info. (Apparently I do.)
Continue reading ‘Counting lines of code in ClearQuest hooks (SQL Server)’
I’m not aware of the history behind it, but Classics is quite a handy little collection of resources when it comes to testing our products against a standard run-of-the-mill ClearQuest schema. It contains all sorts of things like RequisitePro databases and testing stuff, but what I rely on it most for is the ClearQuest CLSIC database it contains.
Continue reading ‘IBM Rational ‘Classics’: Sample ClearQuest and RequisitePro Projects (and who knows what else…)’
