migrate-action-db

migrate-action-db 
<--source-driver-class=value> 
<--source-database-url=value> 
<--source-username=value> 
<--source-password=value> 
<--target-driver-class=value> 
<--target-database-url=value> 
<--target-username=value> 
<--target-password=value>
[-c | --clear-target-action-db]

Overview

Use this command to migrate an action database over to another database, adding to any content on the target database, by default.

Important: Due to the nature of action data, migrate-action-db appends data to an existing database, which can cause duplicated data entries if the user reruns a command.

This action database migration is available only from the migrate-action-db command-line command. See Migrating a database instance for more information.

Options


Option	Optional or Required	Default Value	Description
`--source-driver-class=value`	Required	none	The driver class of the source database.¹
`--source-database-url=value`	Required	none	The database URL of the source database.²
`--source-username=value`	Required	none	The user name of the source database.
`--source-password=value`	Required	none	The password for the user of the source database.
`--target-driver-class=value`	Required	none	The driver class of the target database.¹
`--target-database-url=value`	Required	none	The database URL of the target database.²
`--target-username=value`	Required	none	The user name of the target database.
`--target-password=value`	Required	none	The password for the user of the target database.
`-c --clear-target-action-db`	Optional	false	Clears the target action database of content. By default, the content of the source action database is added to the target action database.

¹ If you are using an Oracle database, then you must first download a supported database driver and place the file (ojdbc*.jar) in the directory <installation files dir>/tomcat/custom-ext.

Example

config migrate-actiondb 
--source-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver
--source-database-url=jdbc:sqlserver://<databaseurl>:1433;DatabaseName=<db-name> 
--source-username=<db-username> --source-password=<db-password> 
--target-driver-class=org.postgresql.Driver
--target-database-url=jdbc:postgresql://<databaseurl>:5432/<db-name> 
--target-username=<db-username> --target-password=<db-password> 
-c

² If you encounter an error that indicates that the driver could not establish a secure connection, see the article Upgrading to 12.3 and later: Fixing Microsoft SQL Server JDBC driver-related issues.