solidDB Help : Replication : Advanced Replication : Using Advanced Replication with applications : Using Advanced Replication data synchronization statements
  
Using Advanced Replication data synchronization statements
Advanced Replication synchronization statements are extensions to solidDB SQL. You can manage distributed data by specifying synchronization operations. You can execute Advanced Replication statements by using the solidDB SQL Editor (solsql). For information about using the solidDB SQL Editor, see solidDB SQL Editor (solsql).
Advanced Replication data synchronization statements let you perform such tasks as registering replica databases, implementing access rights, and creating publications. In addition, you administer the Advanced Replication functionality by using many of these statements. For example, you use MESSAGE statements to create and manage synchronization messages and DROP statements to remove synchronization objects such as publications and subscriptions.
The Advanced Replication statements are grouped into the following categories:
Database configuration statements
You can set up and configure the databases that are used in an Advanced Replication system by using the following SQL statements:
 
Task
Statement
Drop the master database definitions from a replica database
Drop a replica database from the master database
Register a replica database with the master database
MESSAGE APPEND ... REGISTER REPLICA, see MESSAGE APPEND
Configure synchronization
Change the network name associated with a database
Rename a server
Define catalog-level parameters
Define the user name and password to use when the replica database is registered in the master database
Map replica user ids to specified master user ids
Publication statements
You can create and maintain publications, and refresh data from publications, by using the following SQL statements:
 
Task
Statement
Store synchronization history
Create a bookmark in a master database
Remove a bookmark defined in a master database
Create or replace publications
Remove a publication definition from the master database
Remove a publication registration from a replica database
Remove data that is no longer needed in a replica database
Export data from a master database to a file
Import data to a replica database from a data file that was created by the EXPORT SUBSCRIPTION statement
Grant access rights on a publication to a user or role
Revoke access rights to a publication from a user or role
Conserve memory by streaming the associated data
Intelligent Transaction control
You can control the execution of Intelligent Transactions by using the following SQL functions and statements:
 
Task
Function or statement
Read parameters from the parameter bulletin board
Set parameters on the parameter bulletin board
Save transactions in the replica database for propagation to the master database
Set properties in the replica database for a transaction that is saved for propagation to the master database
Message statements
You can create and execute the synchronization messages that are sent between a replica and the master database by using the following SQL MESSAGE statements:
 
Task
Statement
Start a message to send to the replica database
Append tasks to a message that was created in the replica database with the MESSAGE BEGIN statement
Closes a message in a replica database (ready to send to master database)
Send message to the master database
Request a message from the master database, if a reply to a sent message was not received by the MESSAGE FORWARD statement
Re-execute message on the replica database (if the execution of a reply message fails)
Execute a failed message on the master database
Delete a message from the database (in order to recover from an error)
Delete the current transaction from a given message in the master database
Go up to
Using Advanced Replication with applications