ALTER DATABASE
On this page
Specify if an existing database should begin using synchronous or asynchronous replication.
Syntax
ALTER DATABASE <database_name> { SET | WITH } { SYNC | ASYNC } REPLICATION;
Remarks
-
<database_
is the name of the existing database for which you want to specify the replication setting.name> -
This command causes implicit commits.
Refer to COMMIT for more information.
Example
The following example specifies that the database database_
should begin using synchronous replication.
ALTER DATABASE database_name SET SYNC REPLICATION;
Related Topics
Last modified: July 25, 2022