How do I upgrade the Data Synchronization tool (and preserve existing data)?

How do I upgrade the Data Synchronization tool without disrupting to overwriting my existing data?

To upgrade the Data Synchronization tool:

Run the Data Synchronizer installer included on the xMatters installation disc (running the installer does not overwrite existing data).

If you want to reuse your existing data:

  • Rename all of your existing staging tables:

SQL:

EXEC sp_rename 'table_name'  
 'new_table_name'

Oracle:

alter table  
 table_name  
rename to  
 new_table_name;  

SQL:
<xMHOME>\AlarmPoint_DataSync\example\staging_ddl\mssql\data_sync_staging_area.ddl

Oracle:
<xMHOME>\AlarmPoint_DataSync\example\staging_ddl\oracle\data_sync_staging_area.ddl

  • Insert the data from the backup tables into the new staging tables. Note that you have the option of reviewing the staging tables and adding entries to new columns (for staging table details, refer to the Data Synchronization chapter of the xMatters (alarmpoint) installation and administration guide).

xMatters Reference

JDN-1033 Originally created by Don Clark

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk