Database export

Document ID : KB000029389
Last Modified Date : 14/02/2018
Show Technical Document Details

This document outlines the recommended methods for exporting the 3 (MySQL, Oracle, MSSQL) supported database platforms. It is recommended to ask your DBA to perform the exports using the methods outlined below. If you need details related to the database being used by CA Release Automation then this can be found inside of the <NAC/Datamanagement Installation Folder>/webapps/datamanagement/WEB-INF/distributed.properties file. 

 

MySQL

From the MySQL server hosting the CA Release Automation database run the following command to export your Release Automation DB:

mysqldump -u root -p <nolio_db_name> /tmp/nolio-dbdump.sql

The db export will be captured within the /tmp/nolio-dbdump.sql file generated by the command above.

 

Oracle

From the Oracle server hosting the CA Release Automation database:

  1. Login as the sys or user with DBA privilege in SQL*Plus.
  2. Get the path of Oracle dump directory by running this query:
    • select * from dba_directories where directory_name = 'DATA_PUMP_DIR'
  3. Export the database to the DATA_PUMP_DIR directory found in Step2. This command is normally run from the $ORACLE_HOME\bin folder.
    • expdp DIRECTORY=DATA_PUMP_DIR dumpfile=<dump filename> logfile=export.log SCHEMAS=<source schema of RA DB>

The db export will be captured within the <DATA_PUMP_DIR>/<dump filename> generated by the expdp command above.

 

MSSQL

From the MSSQL server hosting the CA Release Automation database:

  1. Open SQL Server Management Studio
  2. Expand "Databases" under the SQL Server connect. Find the CA Release Automation database.
  3. Right click on the CA Release Automation database.
  4. Select Tasks -> Back Up...
  5. Ensure the following properties are set to the values specified:
    • Database: <your CA Release Automation db> 
    • Backup type: Full
    • Backup component: Database
    • Backup set Name: <something descriptive like: nolio-full db backup>
    • Destination:
      • Back up to: Disk
      • It is recommended to remove any (by clicking on the remove button - not going and deleting the file) existing destination files if there are any. This way it does not overwrite an existing backup file. Then click on the Add button. You should be able to accept the default path and just add a <filename>.bak to the end of the already defined path. 
  6. Click OK
  7. Click OK.

The db export will be written to the path shown in step 5 destination.