SQL-level replication management [CORE6285]

[firebird-automations]

Submitted by: @dyemanov

Sometimes it makes sense to set up the replication set (i.e. tables to be replicated) inside the database rather than via the configuration file. Or provide a two-level customization, with tables explicitly included at the database level and excluded using the configuration wildcards.

For that purpose, CREATE TABLE and ALTER TABLE commands are extended with the optional {ENABLE | DISABLE} PUBLICATION clause. Also ALTER DATABASE command is extended with batch operations to manage the replication set:

ALTER DATABASE ADD {ALL | TABLE <comma-separated table list>} TO PUBLICATION
ALTER DATABASE DROP {ALL | TABLE <comma-separated table list>} FROM PUBLICATION

And finally, ALTER DATABASE command now offers an ability to switch the replication ON/OFF at runtime:

ALTER DATABASE {ENABLE | DISABLE} PUBLICATION

See also /doc/replication.md and /doc/sql.extensions/README.ddl.txt.

[firebird-automations]

Commented by: Omacht András (aomacht)

Great feature! Big thanks!

[firebird-automations]

Modified by: @pavel-zotov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

[firebird-automations]

Modified by: @dyemanov

Fix Version: 4.0 Beta 2 [ 10888 ]

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]