Synchronize databases using scheduled events

Synchronizing databases allows you to run reports on up-to-date data.

Before you begin

You must configure your reporting database and at least one event before you can schedule the data synchronization.
Note: If you plan on frequent synchronization for reporting purposes, we recommend that you replicate your database and run reporting against the replicated database. This measure reduces the risk of system timeout or shutdown due to locking of tables in the production database. If, upon trying to save data after replication, you receive an error similar to "System.Data.SqlClient.SqlException (0x80131904): Length of LOB data (88064) to be replicated exceeds configured maximum 65536," use SQL statements to increase the volume of data to replicate.
Note:

For information on setting up database replication, visit the Microsoft Developer Network website and review the article, SQL Server Replication.

When upgrading the application, if you are using a replicated database and have replication turned on, you must turn it off, upgrade, and then turn it on again. You must also upgrade the replicated database.

Procedure

  1. From the navigator, click Proficy System > Proficy System > Reporting > Default Reporting Schedule.
  2. In the Displays panel, click Reporting Schedule Editor. The Default Reporting Schedule editor appears.
  3. To select the event you want to use for database synchronization, in the Synchronization Events area, click Browse.
    The Universal Browser appears.
  4. Click OK, and then click Save.

Synchronization SQL Statements


sp_configure 'max text repl size', 2147483647
GO
RECONFIGURE
GO