Note: This tab is enabled only when the Source DB Connection is set to WAN.
When the target database is across a wide area network (WAN) from the source database, the Pro2 Server must reside on the same local-area-network as the target database server.

When the target database is in a different geographic location than the source Progress database, implementation of Pro2 must include a Progress application server on the source database server in addition to the standard configuration on the Pro2 server. Instead of running the replication procedures via typical client/server mode connections to the source and repl databases, Pro2 will send requests to the application server which returns data to the calling procedure on the Pro2 server. The Pro2 server must be on the same local-area-network as the target database server.

If Pro2 is set up in a WAN environment, you need to check application server connection, synchronize repl table data, build application server processor libraries, transfer files to and from WAN server. Apart from this, you also need to get source side schema, delta DF file and check CRC local vs source.

Check application server connection

Once the AS_Src environments have been configured, the application server connection and communication should be tested and verified before attempting to start replication. You can do that by selecting Submit. Pro2 notifies you if the test was successful or if it failed.

Synchronize Repl Table Data

The Synchronize Repl Table Data functionality enables you to synchronize the repl tables data to application server and download the repl table data files from application server.

To synchronize repl table data, Click Tools → WAN → Synchronize Repl Table Data in the web UI. The Sync Repl Tables window will open. Here you can choose whether to sync the repl tables to application server by selecting Sync to AppSrv radio button, or you can choose to download the repl table data files from the application server using the Data Files From AppSrv radio button.

The Sync to AppSrv button enables you to synchronize the WAN repl database table values while excluding replqueue from your local copy. After performing a sync of WAN replication table data, Pro2 displays all the repl tables that are updated. It also shows the number of records that are updated, deleted, or locked per repl table. The Data Files From AppSrv button enables you to download the WAN repl database table contents while excluding replqueue to your local copy.

Note: If you choose ALL from the drop-down list (Table Name field), then the data files for all table files are created except for replqueue table.

Build AppSrv Processor Libraries

This menu item enables you to build application server process libraries for the selected databases. To build application server process libraries, select the Build AppServ Processor Libraries from the WAN menu and select the databases that you want and click Submit.

Transfer File to/from WAN Server

You can send, receive or delete files from the WAN server using the Transfer File to/from WAN Server menu item. To perform these actions, select Transfer Files to/from WAN Server menu item. Choose the file that you want to perform the action for and click Copy to WAN or Copy to Local depending upon your choice. You can also choose to delete the files from WAN by clicking the Delete button in the WAN Directory section.

Get Source Side Schema

To get the schema of the source side databases, select Get Source Side Schema and select the databases that you want to include and click Submit.

Get Delta DF

You can use the Get Delta DF menu item to retrieve the Delta DF for a source database. To do this, Pro2 connects to a local empty copy of the source DB and generates a Delta DF from the DF of the source DB by removing all area information from the source DF and downloading it through PAS for OpenEdge.

To retrieve the Delta DF, from the WAN menu, click Get Delta DF and select the databases for which you want to retrieve the Delta DF and click Submit.

Check CRC Local vs Source

You can use the Check CRC Local vs. Source menu item to check whether the CRC for Mapped tables in the source databases and the local databases match. To do this, from the WAN menu, select Check CRC Local vs. Source.