ALTER DATABASE

Specify if an existing database should begin using synchronous or asynchronous replication.

Syntax

ALTER DATABASE <database_name> { SET | WITH } { SYNC | ASYNC } REPLICATION;

Remarks

  • <database_name> is the name of the existing database for which you want to specify the replication setting.

  • This command causes implicit commits. Refer to COMMIT for more information.

Example

The following example specifies that the database database_name should begin using synchronous replication.

ALTER DATABASE database_name SET SYNC REPLICATION;

Related Topics

Last modified: July 25, 2022

Was this article helpful?