Spotfire DB switch Oracle → SqlServer

作者Xihui Wang发表在笔记标签：、

To run this command, please turn off any online service.

You need to create Sqlserver DB for the same version of Spotfire first. Then run

C:\tibco\tss\12.0.3\tomcat\spotfire-bin>config migrate-db --tool-password=spotfire --target-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver --target-database-url=jdbc:sqlserver://hostName:1433;DatabaseName=yourSpotfireDBName --target-username=sa --target-password=yourPassword

The log is below:

Connecting to the source database
Connecting to the target database

Database versioning verified.
Database consistency verified.
Warning! This operation will wipe out all the tables from the target database.
Do you wish to continue (Y/N)? Y

Deleting existing data in target table 'ACTIVITY'...Done in 00:00:00
Deleting existing data in target table 'SITE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'SCHEDULED_UPDATES_SETTINGS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_ORIGIN'...Done in 00:00:00
Deleting existing data in target table 'ACTIVE_SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ACCESS'...Done in 00:00:00
Deleting existing data in target table 'PERSISTENT_SESSIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_AUTH_REQUEST'...Done in 00:00:00
Deleting existing data in target table 'INVITES'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_REFRESH_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'LIB_UNRESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTION_CONTENTS'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_USERS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_ACCESS_TOKENS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_KEYS'...Done in 00:00:00
Deleting existing data in target table 'KEYSTORE_PASSWORDS'...Done in 00:00:00
Deleting existing data in target table 'CONFIG_HISTORY'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_CONFIGS'...Done in 00:00:00
Deleting existing data in target table 'JOBS_LATEST'...Done in 00:00:00
Deleting existing data in target table 'EXCLUDED_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'CUSTOMIZED_LICENSES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_VALUES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_KEYS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREA_ALLOWED_GRP'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_NONVER'...Done in 00:00:00
Deleting existing data in target table 'NODE_STATUS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'LIB_VISIBLE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_BLOCKED_USERS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVER_INFO'...Done in 00:00:00
Deleting existing data in target table 'SERVER_CONFIGURATIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_RESOLVED_DEPEND_VER'...Done in 00:00:00
Deleting existing data in target table 'LIB_WORDS'...Done in 00:00:00
Deleting existing data in target table 'NODE_EVENT_BUS'...Done in 00:00:00
Deleting existing data in target table 'JOB_TASKS'...Done in 00:00:00
Deleting existing data in target table 'CONSENTED_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'LIFECYCLE_EVENTS'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS'...Done in 00:00:00
Deleting existing data in target table 'DEP_DISTRIBUTIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_PKGS'...Done in 00:00:00
Deleting existing data in target table 'DEP_PACKAGES'...Done in 00:00:00
Deleting existing data in target table 'SN_VERSION'...Done in 00:00:00
Deleting existing data in target table 'RULES_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'PREFERENCE_OBJECTS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_AUTH_CODES'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CT_CODE_ENTITIES'...Done in 00:00:00
Deleting existing data in target table 'CERTIFICATES'...Done in 00:00:00
Deleting existing data in target table 'TRUSTED_CERTS'...Done in 00:00:00
Deleting existing data in target table 'GROUP_MEMBERS'...Done in 00:00:00
Deleting existing data in target table 'CT_THIRD_PARTY_ROOTCERTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PRINCIPAL_PROPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_APPLICATIONS'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'SERVICE_ATTRIBUTES'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICES'...Done in 00:00:00
Deleting existing data in target table 'NODES'...Done in 00:00:00
Deleting existing data in target table 'DEP_AREAS_DEF'...Done in 00:00:00
Deleting existing data in target table 'NODE_SERVICE_TYPES'...Done in 00:00:00
Deleting existing data in target table 'CT_EXTCERTS'...Done in 00:00:00
Deleting existing data in target table 'JMX_USERS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_FUNCTIONS'...Done in 00:00:00
Deleting existing data in target table 'LICENSE_NAMES'...Done in 00:00:00
Deleting existing data in target table 'CT_CERTS'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CONSENT'...Done in 00:00:00
Deleting existing data in target table 'OAUTH2_CLIENTS'...Done in 00:00:00
Deleting existing data in target table 'LIB_PROPERTIES_VER'...Done in 00:00:00
Deleting existing data in target table 'JOB_INSTANCES'...Done in 00:00:00
Deleting existing data in target table 'ROUTING_RULES'...Done in 00:00:00
Deleting existing data in target table 'RESOURCE_POOLS'...Done in 00:00:00
Deleting existing data in target table 'JOB_SCHEDULES'...Done in 00:00:00
Deleting existing data in target table 'SITES'...Done in 00:00:00
Deleting existing data in target table 'LIB_CURRENT_ITEMS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_VERSIONS'...Done in 00:00:00
Deleting existing data in target table 'LIB_DATA'...Done in 00:00:00
Deleting existing data in target table 'LIB_CHARACTER_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_ENCODINGS'...Done in 00:00:00
Deleting existing data in target table 'LIB_CONTENT_TYPES'...Done in 00:00:00
Deleting existing data in target table 'USERS'...Done in 00:00:00
Deleting existing data in target table 'GROUPS'...Done in 00:00:00
Deleting existing data in target table 'LIB_ITEM_TYPES'...Done in 00:00:00

Copying table LIB_ITEM_TYPES
Table LIB_ITEM_TYPES done. Copied 26 rows in 00:00:00

Copying table GROUPS
Table GROUPS done. Copied 13 rows in 00:00:00


Copying table USERS
Table USERS done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_TYPES
Table LIB_CONTENT_TYPES done. Copied 7 rows in 00:00:00

Copying table LIB_CONTENT_ENCODINGS
Table LIB_CONTENT_ENCODINGS done. Copied 2 rows in 00:00:00

Copying table LIB_CHARACTER_ENCODINGS
Table LIB_CHARACTER_ENCODINGS done. Copied 1 rows in 00:00:00

Copying table LIB_DATA
Table LIB_DATA done. Copied 22 rows in 00:00:00

Copying table LIB_ITEM_VERSIONS
Table LIB_ITEM_VERSIONS done. Copied 22 rows in 00:00:00

Copying table LIB_CURRENT_ITEMS
Table LIB_CURRENT_ITEMS done. Copied 15 rows in 00:00:00


Copying table SITES
Table SITES done. Copied 1 rows in 00:00:00

Copying table JOB_SCHEDULES
Table JOB_SCHEDULES done. Copied 0 rows in 00:00:00

Copying table RESOURCE_POOLS
Table RESOURCE_POOLS done. Copied 0 rows in 00:00:00

Copying table ROUTING_RULES
Table ROUTING_RULES done. Copied 0 rows in 00:00:00

Copying table JOB_INSTANCES
Table JOB_INSTANCES done. Copied 0 rows in 00:00:00

Copying table LIB_PROPERTIES_VER
Table LIB_PROPERTIES_VER done. Copied 268 rows in 00:00:00

Copying table OAUTH2_CLIENTS
Table OAUTH2_CLIENTS done. Copied 5 rows in 00:00:00

Copying table OAUTH2_CONSENT
Table OAUTH2_CONSENT done. Copied 0 rows in 00:00:00

Copying table CT_CERTS
Table CT_CERTS done. Copied 1 rows in 00:00:00

Copying table LICENSE_NAMES
Table LICENSE_NAMES done. Copied 10 rows in 00:00:00

Copying table LICENSE_FUNCTIONS
Table LICENSE_FUNCTIONS done. Copied 261 rows in 00:00:00

Copying table JMX_USERS
Table JMX_USERS done. Copied 0 rows in 00:00:00

Copying table CT_EXTCERTS
Table CT_EXTCERTS done. Copied 0 rows in 00:00:00

Copying table NODE_SERVICE_TYPES
Table NODE_SERVICE_TYPES done. Copied 2 rows in 00:00:00

Copying table DEP_AREAS_DEF
Table DEP_AREAS_DEF done. Copied 1 rows in 00:00:00

Copying table NODES
Table NODES done. Copied 2 rows in 00:00:00

Copying table NODE_SERVICES
Table NODE_SERVICES done. Copied 3 rows in 00:00:00

Copying table SERVICE_ATTRIBUTES
Table SERVICE_ATTRIBUTES done. Copied 22 rows in 00:00:00

Copying table NODE_SERVICES_ATTRIBUTES
Table NODE_SERVICES_ATTRIBUTES done. Copied 17 rows in 00:00:00

Copying table LIB_APPLICATIONS
Table LIB_APPLICATIONS done. Copied 29 rows in 00:00:00

Copying table LIB_PRINCIPAL_PROPS
Table LIB_PRINCIPAL_PROPS done. Copied 0 rows in 00:00:00

Copying table CT_THIRD_PARTY_ROOTCERTS
Table CT_THIRD_PARTY_ROOTCERTS done. Copied 0 rows in 00:00:00

Copying table GROUP_MEMBERS
Table GROUP_MEMBERS done. Copied 11 rows in 00:00:00

Copying table TRUSTED_CERTS
Table TRUSTED_CERTS done. Copied 0 rows in 00:00:00

Copying table CERTIFICATES
Table CERTIFICATES done. Copied 4 rows in 00:00:00

Copying table CT_CODE_ENTITIES
Table CT_CODE_ENTITIES done. Copied 0 rows in 00:00:00

Copying table TRUSTED_CODE_ENTITIES
Table TRUSTED_CODE_ENTITIES done. Copied 0 rows in 00:00:00

Copying table OAUTH2_AUTH_CODES
Table OAUTH2_AUTH_CODES done. Copied 0 rows in 00:00:00

Copying table PREFERENCE_OBJECTS
Table PREFERENCE_OBJECTS done. Copied 0 rows in 00:00:00

Copying table RULES_SCHEDULES
Table RULES_SCHEDULES done. Copied 0 rows in 00:00:00

Copying table SN_VERSION
Table SN_VERSION done. Copied 1 rows in 00:00:00

Copying table DEP_PACKAGES
Table DEP_PACKAGES done. Copied 125 rows in 00:00:34

Copying table NODE_SERVICES_PKGS
Table NODE_SERVICES_PKGS done. Copied 148 rows in 00:00:00

Copying table DEP_DISTRIBUTIONS
Table DEP_DISTRIBUTIONS done. Copied 1 rows in 00:00:00

Copying table DEP_AREAS
Table DEP_AREAS done. Copied 1 rows in 00:00:00

Copying table LIFECYCLE_EVENTS
Table LIFECYCLE_EVENTS done. Copied 11 rows in 00:00:00

Copying table CONSENTED_ENTITIES
Table CONSENTED_ENTITIES done. Copied 0 rows in 00:00:00

Copying table JOB_TASKS
Table JOB_TASKS done. Copied 0 rows in 00:00:00

Copying table NODE_EVENT_BUS
Table NODE_EVENT_BUS done. Copied 465 rows in 00:00:00

Copying table LIB_WORDS
Table LIB_WORDS done. Copied 72 rows in 00:00:00

Copying table LIB_RESOLVED_DEPEND_VER
Table LIB_RESOLVED_DEPEND_VER done. Copied 2 rows in 00:00:00

Copying table SERVER_CONFIGURATIONS
Table SERVER_CONFIGURATIONS done. Copied 2 rows in 00:00:00

Copying table NODE_SERVER_INFO
Table NODE_SERVER_INFO done. Copied 3 rows in 00:00:00

Copying table CT_BLOCKED_USERS
Table CT_BLOCKED_USERS done. Copied 0 rows in 00:00:00

Copying table LIB_VISIBLE_TYPES
Table LIB_VISIBLE_TYPES done. Copied 189 rows in 00:00:00

Copying table NODE_SERVICES_RESOURCE_POOLS
Table NODE_SERVICES_RESOURCE_POOLS done. Copied 0 rows in 00:00:00

Copying table NODE_STATUS
Table NODE_STATUS done. Copied 4 rows in 00:00:00

Copying table LIB_PROPERTIES_NONVER
Table LIB_PROPERTIES_NONVER done. Copied 38 rows in 00:00:00

Copying table DEP_AREA_ALLOWED_GRP
Table DEP_AREA_ALLOWED_GRP done. Copied 0 rows in 00:00:00

Copying table PREFERENCE_KEYS
Table PREFERENCE_KEYS done. Copied 15 rows in 00:00:00

Copying table PREFERENCE_VALUES
Table PREFERENCE_VALUES done. Copied 15 rows in 00:00:00

Copying table CUSTOMIZED_LICENSES
Table CUSTOMIZED_LICENSES done. Copied 13 rows in 00:00:00

Copying table EXCLUDED_FUNCTIONS
Table EXCLUDED_FUNCTIONS done. Copied 32 rows in 00:00:00

Copying table JOBS_LATEST
Table JOBS_LATEST done. Copied 0 rows in 00:00:00

Copying table SERVICE_CONFIGS
Table SERVICE_CONFIGS done. Copied 3 rows in 00:00:00

Copying table CONFIG_HISTORY
Table CONFIG_HISTORY done. Copied 2 rows in 00:00:00

Copying table KEYSTORE_PASSWORDS
Table KEYSTORE_PASSWORDS done. Copied 1 rows in 00:00:00

Copying table OAUTH2_KEYS
Table OAUTH2_KEYS done. Copied 1 rows in 00:00:00

Copying table OAUTH2_ACCESS_TOKENS
Table OAUTH2_ACCESS_TOKENS done. Copied 0 rows in 00:00:00

Copying table TRUSTED_USERS
Table TRUSTED_USERS done. Copied 0 rows in 00:00:00

Copying table DEP_DISTRIBUTION_CONTENTS
Table DEP_DISTRIBUTION_CONTENTS done. Copied 125 rows in 00:00:00

Copying table LIB_UNRESOLVED_DEPEND_VER
Table LIB_UNRESOLVED_DEPEND_VER done. Copied 0 rows in 00:00:00

Copying table OAUTH2_REFRESH_TOKENS
Table OAUTH2_REFRESH_TOKENS done. Copied 4 rows in 00:00:00

Copying table INVITES
Table INVITES done. Copied 0 rows in 00:00:00

Copying table NODE_AUTH_REQUEST
Table NODE_AUTH_REQUEST done. Copied 0 rows in 00:00:00

Copying table PERSISTENT_SESSIONS
Table PERSISTENT_SESSIONS done. Copied 0 rows in 00:00:00

Copying table LIB_ACCESS
Table LIB_ACCESS done. Copied 8 rows in 00:00:00

Copying table ACTIVE_SERVICE_CONFIGS
Table ACTIVE_SERVICE_CONFIGS done. Copied 2 rows in 00:00:00

Copying table LICENSE_ORIGIN
Table LICENSE_ORIGIN done. Copied 706 rows in 00:00:00

Copying table SCHEDULED_UPDATES_SETTINGS
Table SCHEDULED_UPDATES_SETTINGS done. Copied 0 rows in 00:00:00

Copying table SITE_SERVICE_CONFIGS
Table SITE_SERVICE_CONFIGS done. Copied 0 rows in 00:00:00

Copying table ACTIVITY
Table ACTIVITY done. Copied 0 rows in 00:00:00

Migration completed.

Please run the 'update-bootstrap' command in order to update the existing bootstrap configuration file(s) with new (target) database configs.

To do this for the action log:

C:\tibco\tss\12.0.3\tomcat\spotfire-bin>config migrate-action-db --source-driver-class=oracle.jdbc.OracleDriver --source-database-url=jdbc:oracle:thin:@//hostname:1521/orcl --source-username=spotfire_actionlog --source-password=spotfire --target-driver-class=com.microsoft.sqlserver.jdbc.SQLServerDriver --target-database-url=jdbc:sqlserver://hostname:1433;DatabaseName=yourSpotfireDBName --target-username=yourSpotfireActionDBUserName --target-password=yourPassword

Connecting to the source database
Connecting to the target database
Copying table ACTIONLOG

Table ACTIONLOG done. Copied 143072 rows in 00:00:09

Migration completed

test on win server 2022, Spotfire 12.0 LTS, oracle 19.3, SqlServer 2019 Standard

留下评论

通过 WordPress.com 设计一个这样的站点
从这里开始