Use create subscription command for Direct Load Materialization

Use create subscription with the direct_load option to create a subscription with direct load materialization.

The syntax is:
create subscription subscription
	for table_rep_def
	with replicate at data_server.database
	[where search_conditions]
	without holdlock
	direct_load

where subscription is the name of the subscription to activate, table_rep_def is the name of the table replication definition you are subscribing to, and data_server.database identifies the replicate database.

Unlike other automatic materialization methods, data selected from the primary table is loaded directly to the replicate database—no materialization queue is used—as soon as it is returned from the select command. This option is for subscriptions to table replication definitions only and is used with without holdlock. It cannot be used with without materialization or incrementally.