Archive for March, 2008

Relocating, moving or copying ClearQuest schema and user databases using database vendor facilities

Published by Trent Nelson on March 3, 2008 in ClearQuest, SQL, SQL Server, DB2, Oracle and Databases. 0 Comments

This blog describes the process for moving or copying ClearQuest schema and user databases between two separate database instances using the database vendor’s native facilities. This approach has a few of advantages over the standard Move /Copy Database facilities provided by ClearQuest (either those used via the Maintenance Tool or Designer, or via command line utilities like installutil.exe):

  1. Speed. Restoring a database using the database vendor’s facilities is always quicker than the facilities ClearQuest provides.
  2. No network connectivity required. ClearQuest’s facilities require simultaneous access to the source and destination database instances. This isn’t always desirable or possible.

The approaches shown in this blog apply to Oracle, DB2 and SQL Server.
Continue reading ‘Relocating, moving or copying ClearQuest schema and user databases using database vendor facilities’

All you ever wanted to know about ClearQuest IDs…

Published by Trent Nelson on March 3, 2008 in ClearQuest. 0 Comments 


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 ‘All you ever wanted to know about ClearQuest IDs…’


							
 

		
 

		
	



		
 
			
 

	

 



 



	

 

	



 























 

; Maximum allowed size for uploaded files.
upload_max_filesize = 100M