Getting started with data synchronization - evaluation setup
This section gives instructions on setting up a simple advanced replication system that demonstrates the basic functionality of synchronizing data between two databases. The section contains sample scripts that are also included in the solidDB® installation package.
Fast path: Instead of going through the steps in this section and setting up the evaluation environment manually, you can use the sample scripts available in the samples/replication/eval_setup directory of the solidDB® package. You can run the sample scripts in an automated mode or execute them manually. For more information about using the sample, see the readme.txt file in the samples/replication/eval_setup directory.
Before you start
The evaluation setup procedure assumes familiarity with working with solidDB®, such as the following:
▪Basic administration of solidDB®, such as installing, starting, shutting down, configuring network names, and so on
▪Working with solidDB®, such as connecting to the database, running SQL statements
Tip: In advanced replication, synchronization is implemented with SQL statements. The data synchronization SQL statements described in this section can be used through solidDB® SQL Editor (solsql), as well as through the ODBC and JDBC APIs.
▪solidDB® SQL stored procedure programming
▪Fundamentals of solidDB® advanced replication architecture
Tip: The getting started steps and scripts use a number of system stored procedures to configure the synchronization environment. Instead of using the stored procedures, you can configure the environment by using SQL statements. For more information about the SQL statements, see Setting up databases for synchronization.
If for some reason the set up of the advanced replication environment using the stored procedures fail, you might need to use the SQL statements to remove and modify configuration information.