Migrating a database instance
Starting with version 11.4.0 of Spotfire Server, you can use command-line commands to migrate a Spotfire database instance or an action database instance from one to another.
About this task
migrate-db
: Migrates a Spotfire Server database from one database to another after deleting the contents on the target database.migrate-action-db
: Migrates an action database from one database to another. By default, the content of the source action database is added to the target action database.
Before you begin
- Create a working backup of your Spotfire database.
- You must have created the new Spotfire database, with the same version, in the database instance to which you are migrating.
If you are migrating a database for a Spotfire Server cluster, then
you must update the
bootstrap.xml files for all of the servers in the
cluster. If the
migrate-db
command's flag
--update-bootstrap is specified, then
migrate-db
updates the
bootstrap.xml file for the server from which you
are running the command.
Procedure
Example
The following example demonstrates migrating the Spotfire database
from its current database engine to a target PostgreSQL database from a Linux
system. (If you are on a Windows system, use the command
config.bat
.)
config.sh migrate-db --tool-password=tool_password
--target-driver-class=org.postgresql.Driver
--target-database-url=jdbc:postgresql://my_host_name:5432/my_postgresql_db
--target-username=jdoe --target-password=my_target_pw