Database Replication Definition Commands

A database replication definition describes the database or database objects to be replicated. You can choose to replicate the entire database, or you can choose to replicate—or not replicate—particular tables, functions, transactions, DDL, and system stored procedures in that database.

The database replication definition includes:

The name of the database replication definition
The name of the primary server where the database to be replicated is located
The name of the database to be replicated

The database replication definition can optionally include:

An indicator on whether to replicate the DDL to subscribing databases
An indicator on whether to replicate tables, stored procedures, user-defined functions, transaction, or system procedures to subscribing databases

Use these commands to work with database replication definitions:

create database replication definition – creates a replication definition for replicating a database or a database object.
alter database replication definition – changes an existing database replication definition.
drop database replication definition – deletes an existing database replication definition.