EditAttachPrintable
r2 - 2018-08-20 - 12:24:41 - PaulEllisYou are here: TWiki >  Deployment Web > DeploymentMigratingAndEvolving > MigratingYourJazzAuthorizationServerFromDerbyToAnEnterpriseDatabase

Migrating Your Jazz Authorization Server From Derby To An Enterprise Database uc.png

Authors: DavidNoecker, MirkoHartwig
Build basis: Jazz Authorization Server 6.0.x+

How to migrate your database from Derby to another COTS (Common Off The Shelf) database


1.) On JTS export JTS *.json file with

./repotools-jts.sh -prepareJsaSsoMigration adminUserId=<your Admin User> adminPassword=<your Admin Password> repositoryURL=https://[public-url]:[port]/jts  toFile=JTS_output.json 

2.) Repeat on all other Applications, such as CCM, for example:

./repotools-ccm.sh -prepareJsaSsoMigration adminUserId=<your Admin User> adminPassword=<your Admin Password> repositoryURL=https://[public-url]:[port]/ccmtoFile=CCM_output.json 

Attention: please check twice when you create *.json files for all existing applications (use the corresponding repotools-xxx.sh for each application)

3.) stop JAS and move to your DB choice described with this link: https://jazz.net/wiki/bin/view/Deployment/PerformanceClusteredJAS

4.) start JAS and test your configuration as described in this link: https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/c_jsasso_jas_deploy_start.html&scope=null

5.) Migrate created *.json files starting with JTS using

 ./repotools-jts.sh -migrateToJsaSso authServerUrl=https://[jas-url]:9643/oidc/endpoint/jazzop authServerUserId=<your Admin User> authServerPassword=<your Admin Password> 
jtsSsoDataFile=JTS_output.json 

6.) Then migrate all other application using as example fo CCM:

./repotools-ccm.sh -migrateToJsaSso authServerUrl=https://[jas-url]:9643/oidc/endpoint/jazzop authServerUserId=<your Admin User> authServerPassword=<your Admin Password> 
jtsSsoDataFile=JTS_output.json appSsoDataFile=CCM_output.json

7.) After migration, startup all Application beginning with JTS

8.) Test availability of all Application after start up

Attention: please be aware that LDX/LQE/JRS may not be available so please try to unregister and reregister these applications after your Test step 9.)

Related topics: Deploying and starting Jazz Authorization Server, Setting up a cluster of Jazz Authorization Servers

External links:

Additional contributors: ShubjitNaik, PaulEllis, TobiasBurkhardt

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r4 < r3 < r2 < r1 | More topic actions...
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.