Before you create your database schema, you must define your database catalogs as master catalogs, replica catalogs, or both by using the SET SYNC statement, see SET SYNC. You can use solidDB SQL Editor (solsql) to enter the statements required for set up.
The current database catalog can be defined with the SET CATALOG statement, see SET CATALOG. If no catalog is specified, the base catalog is used.
Examples
To specify a catalog on a dedicated master database, enter the following statement on the server:
SET SYNC MASTER YES; COMMIT WORK;
To specify a catalog for a dual role (that is, a middle tier database of a multi-tier synchronization hierarchy), enter the following statement on the server:
SET SYNC MASTER YES; SET SYNC REPLICA YES; COMMIT WORK;
For each catalog on a dedicated replica database, enter the following statement on the server: