Copying configuration and database files
To preserve data from your previous System Console, copy configuration and database files from your previous System Console to System Console 3.1.1. This operation consists of the following tasks:
*Shutting down System Console 3.1.1
*Backing up and deleting PostgreSQL database files from the System Console 3.1.1 installation
*Copying the files
Shutting down System Console 3.1.1
Before you can copy files from your previous System Console to System Console 3.1.1, you must shut down System Console 3.1.1.
*If you installed System Console as Windows services
Using the Windows Services applet, stop the Actuate Apache Tomcat 7 for System Console service, then stop the Actuate PostgreSQL for System Console Service, in that order.
*If you did not install System Console as Windows services
Use the procedure described in How to stop System Console processes.
Shutting down and disabling your existing System Console
If you have not already done so, you must disable your previous System Console before copying files into System Console 3.1.1. See Disabling your existing System Console.
Deleting PostgreSQL database files
Before you can copy files from your previous System Console to System Console 3.1.1, you must delete PostgreSQL database files that the System Console 3.1.1 installation created. These files are contained in the database\data folder in the home folder of System Console 3.1.1.
How to delete database files
1 Open a command window having administrative privileges.
2 Navigate to the database folder within the System Console 3.1.1 home folder, for example:
cd \Actuate3\SystemConsole\modules\SystemConsole\database
3 Create a backup copy of the data folder and move that folder out of the database folder.
4 Use the rmdir command to delete the data folder:
rmdir /s/q data
Copying the files
To complete the System Console upgrade, you copy the configuration and database files from your previous System Console to System Console 3.1.1.
Copying files from the same machine
If you installed System Console 3.1.1 onto the same machine where your previous System Console is installed, perform the tasks in this section.
How to copy configuration and data files from the same machine
1 Navigate to the database folder within the System Console 3.1.1 home folder, for example:
cd \Actuate3\SystemConsole\modules\SystemConsole\database
2 Use the xcopy command to copy the data folder from your previous System Console to System Console 3.1.1. Use the /o option to preserve ownership and permissions. Use a trailing backslash (\) on the xcopy target to indicate it is a folder, for example:
xcopy /e/o/q \Actuate3\SystemConsole_OLD\modules\SystemConsole
\database\data data\
3 Navigate to the WEB-INF folder within the System Console 3.1.1 home folder, for example:
cd \Actuate3\SystemConsole\modules\SystemConsole\tomcat\webapps
\sysconsole\WEB-INF
4 As a best practice, make backup copies of the following System Console 3.1.1 files:
*.configured
*umcconfig.xml
*web.xml
5 Use the xcopy command to copy configuration files from your previous System Console to System Console 3.1.1. Use the /o option to preserve ownership and permissions, for example:
xcopy /o/q/y \Actuate3\SystemConsole_OLD\modules\SystemConsole
\tomcat\webapps\sysconsole\WEB-INF\.configured
xcopy /o/q/y \Actuate3\SystemConsole_OLD\modules\SystemConsole
\tomcat\webapps\sysconsole\WEB-INF\umcconfig.xml
xcopy /o/q/y \Actuate3\SystemConsole_OLD\modules\SystemConsole
\tomcat\webapps\sysconsole\WEB-INF\web.xml
Copying files from a different machine
If you installed System Console 3.1.1 onto a different machine from where your previous System Console is installed, you share the old System Console folders containing the files to be copied to allow the machine on which System Console 3.1.1 is installed to access the contents of the folders. Then, you copy the files to System Console 3.1.1.
How to copy configuration and data files from a different machine
1 On the machine where your previous System Console is installed, use Windows Explorer to navigate to the System Console home folder. For example:
C:\Actuate3\SystemConsole\modules\SystemConsole
2 Share the database folder. Grant read privilege on the folder, allowing the machine on which you installed System Console 3.1.1 to read the folder contents.
3 On the machine where you installed System Console 3.1.1, open a command prompt having administrative privileges.
4 Navigate to the database folder in the System Console 3.1.1 installation. For example:
cd C:\Actuate3\SystemConsole\modules\SystemConsole\database
5 Use the xcopy command to copy the data folder from your previous System Console to System Console 3.1.1. Specify the path of the folder you are copying using UNC format. Use a trailing backslash (\) on the xcopy target to indicate it is a folder. The following command copies the old System Console data folder from the shared database folder on a machine named HULU, creating a new folder named data in C:\Actuate3\SystemConsole\modules
\SystemConsole\database on the machine where System Console 3.1.1 is installed:
xcopy \\HULU\database\data data\ /e/q
6 On the machine where your previous System Console is installed, use Windows Explorer to navigate to the \tomcat\webapps\sysconsole folder inside the System Console home folder. For example:
C:\Actuate3\SystemConsole\modules\SystemConsole\tomcat\webapps
\sysconsole
7 Share the WEB-INF folder. Grant read privilege on the folder, allowing the machine on which you installed System Console 3.1.1 to read the folder contents.
8 In the command prompt on the machine where you installed System Console 3.1.1, navigate to the \tomcat\webapps\sysconsole\WEB-INF folder inside the System Console 3.1.1 home folder. For example:
cd C:\Actuate3\SystemConsole\modules\SystemConsole\tomcat\webapps\sysconsole\WEB-INF
9 As a best practice, make backup copies of the following files:
*.configured
*umcconfig.xml
*web.xml
10 Use the xcopy command to copy each configuration file from your previous System Console to System Console 3.1.1. Specify each configuration file path using UNC format. The following commands copy the configuration files from the shared WEB-INF folder on a machine named HULU to the machine where System Console 3.1.1 is installed:
xcopy \\HULU\WEB-INF\.configured /q/y
xcopy \\HULU\WEB-INF\umcconfig.xml /q/y
xcopy \\HULU\WEB-INF\web.xml /q/y