This chapter describes setting up and managing replicated tables.
You can copy data from one database to another in different ways depending on which method best suits the needs at your site:
Using a single database replication definition that lets you choose whether or not to replicate individual tables, transactions, functions, system stored procedures, and data definition language (DDL).
See Chapter 12, “Managing Replicated Objects Using Multisite Availability,” for more information about database replication definitions and multisite availability (MSA).
Using function replication definitions, where each one identifies a specific system stored procedure for replication.
See Chapter 10, “Managing Replicated Functions,” for information about setting up and managing function replication definitions.
Using table replication definitions, where each one identifies a specific table for replication and, optionally, specifies a subset of columns to be replicated.
This chapter discusses the preparations, the procedures, and the specific commands used to manage replicate tables, table replication definitions, and publications.
