Use the validate subscription command to complete the bulk materialization process and set the subscription status to VALID.
Execute validate subscription at the Replication Server where you created the subscription. The syntax is:
validate subscription subscription
for { table_ref_def | function_rep_def | publication pub_name |
database replication definition db_repdef
with primary at data_server.db }
with replicate at data_server.db
where subscription is the name of the subscription to validate, table_rep_def is the name of the table replication definition the subscription is for, function_rep_def is the name of the function replication definition the subscription is for, pub_name is the publication the subscription is for, db_repdef is the database replication definition the subscription is for, and data_server.db identifies the primary or replicate database.
