I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber.
The object I want to replicate is an indexed view. The base tables exist only on the publisher.
The replication fails due to the following error:
Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber
It is true that the view doesn't exist in the subscription database. How can i create it without the base tables?