Manage Database Subscriptions

When you create a database replication definition at the primary database, you must also create a database subscription at each subscribing database.

You can use the no materialization method or the bulk materialization method. If you create a database subscription, you cannot use a where clause to set the criteria for subscribed data; all data is subscribed.

If you need to set criteria for particular tables or functions, you can add table or function subscriptions concurrently.

When there is a database subscription, the DSI for that connection is always treated as if for regular replication. That is, the dsi_replication parameter is off, and the dsi_keep_triggers parameter is on.

When there is a database subscription—and table and function replication definitions—but there are no table or function subscriptions:
Related concepts
Concurrently Using Database, Table, and Function Subscriptions