You can create your own Transact-SQL statements to update the primary database and then view the updates at the replicate database. For example, using the database replication definition and database subscription created during configuration, you can perform these actions and watch the changes appear at the replicate database:
Add information to a table using the insert command.
Delete information from a table using the delete command.
Create and populate a table using the create table and then the insert command.
Depopulate a table using the truncate table command.
You can create your own database replication definitions that filter out specified tables, transactions, or data definition language (DDL) commands.
See Chapter 12, “Managing Replicated Objects Using MultiSite Availability,” in the Replication Server Administration Guide Volume 1 for more information about creating database replication definitions and subscriptions, and customizing your replication environment.
