Sending An Initial Load

Use Case

Data is present in tables before a synchronization solution was put in place. As a result these tables need to be loaded to a target node. As part of this process the tables also need to be created.

In SymmetricDS this process is called an Initial Load

Solution

Before sending an initial load to a target node there are 2 parameters that you might want to turn on.

• initial.load.create.first - By default this value is false. Setting this to true will ensure that any tables not found on the target will be created as part of the initial load process.

• initial.load.delete.first - By default this value is false. Setting this to true will ensure that all tables will be purged on the target as part of the initial load process.

Note

All tables that have triggers and routers setup for the target node will be used during the initial load process.

Sending the initial load

1. Click the "Manage" tab
2. Click the "Node" left menu
3. Right click the node to send the initial load to (node "001" below)
4. Select "Request Initial Load To"

Verify

In order to verify the initial load was sent you can look at the outgoing loads side menu screen under the manage tab. This will show the node the batch was sent to the time that it was created and the duration of time it took to send. You can uncheck the active only box in the event the load already finished before you hit this screen.

In order to look at the individual batches used for this load you can look at the outgoing batches side menu screen under the manage tab. Select the reload channel and either OK status or all statuses and even node if necessary to filter the results.

Further Reading

User Guide - Initial Loads