Difference between revisions of "Custom Installations Backup"

From SmartHCM Wiki
Jump to navigation Jump to search
(Created page with "Category:System Administration == Introduction == This document explains the process of moving an SmartHCM installation from one machine to another. An example scenario i...")
 
Line 13: Line 13:
 
To create a dump file of the database:
 
To create a dump file of the database:
  
 +
<pre>
 
expdp system/password directory=oracle_dump schemas=smarthcmdb dumpfile=smarthcmdb.dmp logfile=smarthcmdb.log
 
expdp system/password directory=oracle_dump schemas=smarthcmdb dumpfile=smarthcmdb.dmp logfile=smarthcmdb.log
 +
</pre>
  
In this case the user 'system' password is 'password' and database name is 'smarthcmdb'.
+
In this case the user 'system' password is 'password' and database schema name is 'smarthcmdb'.

Revision as of 09:36, 30 June 2015


Introduction

This document explains the process of moving an SmartHCM installation from one machine to another. An example scenario is the migration of SmartHCM in production under Microsoft Windows to a Linux server for Database.

Files

Take the SmartHCM directory and create a compressed and portable file with it (eg. zip or tar.gz). Once we have the SmartHCM.zip, move it to the target machine. Unzip this file to the desired target directory.

Database

Export the Old Oracle Database

To create a dump file of the database:

expdp system/password directory=oracle_dump schemas=smarthcmdb dumpfile=smarthcmdb.dmp logfile=smarthcmdb.log

In this case the user 'system' password is 'password' and database schema name is 'smarthcmdb'.