To copy Marketing Event statistical data from a production machine to a development or staging server:
- From a command line, change to the following directory on the production server:
WC_installdir/bin
WC_installdir\bin
- Run the ExportStats command by entering the following (Note: All of the parameters are mandatory):
ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
-Pdatabase_password -Foutput_file_name-Ttable_name
ExportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id
-Pdatabase_password -Foutput_file_name -Ttable_name
ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
-Pdatabase_password -Foutput_file_name -Ttable_name
ExportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id
-Pdatabase_password -Foutput_file_name -Ttable_name
ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
-Pdatabase_password -Foutput_file_name -Ttable_namewhere:
- database_type
is the type of database you are using, either DB2 or Oracle.
is the type of database you are using, DB400.
database_name
- The name of the database.
- database_user_id
- is the user ID of the database owner.
This is also known as the instance user profile.
- database_password
- is the password for the database owner ID.
- output_file_name
- is the path and name of the output file with an .xml extension (if no path is specified, the default is the current directory).
- table_name
- is the name of the database table that you want to export.
This will create an XML file.
- Transfer the XML file to the development or staging server.
- Place the XML file in the following directory on the development or staging server:
WC_installdir/bin
WC_installdir\bin
- Run the ImportStats command by entering the following:
ImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
-Finput_file_name
ImportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
-Finput_file_nameImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
-Finput_file_name
ImportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
-Finput_file_name
ImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
-Finput_file_name where:- database_type
is the type of database you are using, either DB2 or Oracle.
is the type of database you are using, DB400.
- database_name
The name of your database. DB2 users enter the simple name of their database. Oracle users identify their database using the following format: hostname:port:sid identifying the hostname of the database server, the port number of the server, and the system ID.
- database_user_id
- is the user ID of the database owner.
This is also known as the instance user profile.
- database_password
- is the password for the database owner ID.
- input_file_name
- is the path and name of the output file created with the ExportStats utility in step 2 (if no path is specified, the default is the current directory).
This will delete any statistical information in the development or staging server database, and import the statistics.