Issue Details (XML | Word | Printable)

Key: CORE-6285
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

SQL-level replication management

Created: 20/Apr/20 11:12 AM   Updated: 22/Apr/20 07:04 AM
Component/s: Engine
Affects Version/s: 4.0 Beta 1
Fix Version/s: 4.0 Beta 2

QA Status: Done successfully


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Omacht András added a comment - 20/Apr/20 11:27 AM
Great feature! Big thanks!