Sync Tool

The Metrix Sync CLI’s Sync tool provides users with the ability to create a local copy of their Metrix data, within a locally configured SQL Server database environment. The sync processes can be configured to run periodically through Scheduled Tasks (or other cron-job runners) and each sync operation will update only the records that have been altered since it was last run.

Using the Metrix Sync CLI Sync tool

The following sections are detailed within this section of the help-guide:

  1. Creating a compliant database: Instructions for setting up a SQL Server database with the required collation for the Metrix Sync CLI tool.
  2. Configuring Sync: One time configuration of the Metrix Sync CLI tool, including setting up the connection to the local SQL Server database and specifying any required parameters.
  3. Running Sync Pull: Pulling the latest data from the Metrix platform into the local SQL Server database, ensuring that only the records that have changed since the last sync are updated. If no previous sync has occured, the tool will perform a full initial sync, pulling all available data into the local database.
  4. Rebuilding the Local Database: A troubleshooting option that fully rebuilds your local SQL Server database, without pulling any new data from the Metrix platform. This can be useful if a configuration adjustment has not come through as expected.