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:
EXEC sp_rename 'table_name' 'new_table_name'
alter table table_name rename to new_table_name;
- 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).
JDN-1033 Originally created by Don Clark