migrate-db

migrate-db
[-b value | --bootstrap-config=value] 
<-t value | --tool-password=value> 
<--target-driver-class=value>
<--target-database-url=value>
[--target-username=value]
[--target-password=value]
[-f | --force]
[-n | --no-prompt]
[-u | --update-bootstrap]

Overview

Use this command to migrate the contents of a Spotfire database.

Important: The database migration command deletes the contents of the target database before it migrates the entirety of the source database. Repeating the migration command deletes the contents of the target database before migrating content. Be cautious when specifying the target database.

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

To migrate an action database, use migrate-action-db.

Options


Option	Optional or Required	Default Value	Description
`-b value --bootstrap-config=value`	Optional	none	The path to the bootstrap configuration file. The credentials in this file are used as source for the migration. See Bootstrap.xml file for more information about this file.
`-t value --tool-password=value`	Optional	none	The configuration tool password used to decrypt the database password in the bootstrap.xml file. If the tool password is omitted, the command prompts the user for it in the console. See Bootstrap.xml file for more information.
`--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`	Optional	none	The user name of the target database.
`--target-password=value`	Optional	none	The password for the user of the target database.
`-f --force`	Optional	none	Specify this to skip database verification on the both source and target database.
`-n --no-prompt`	Optional	none	Specifies that the command does not prompt for confirmation.
`-u --update-bootstrap`	Optional	none	Specifies that the existing bootstrap configuration file should be updated with the new (target) database configurations without having to run the `update-bootstrap` command explicitly.

¹ 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-db 
--target-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver 
--target-database-url=jdbc:sqlserver://<databaseurl>:1433;DatabaseName=<db-name> 
--target-username=<db-username> --target-password=<db-password> 
-u

² 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.