I obviously don't understand how merge replication works. I have created a publication and a subscriber. The subscriber database does not have some views that the publisher does.
I imagined that the first thing the replication would do is take a copy of the publication as a snapshot and put that on the subscriber database, but when I initialize and start the merge agent it fails, these are the errors shown...it's complaining that one of the views isn't present on the subscriber, but I thought it would create it.
Thanks in advance for your help. No rush, it's Friday afternoon here and I have just about had enough in the office!
• The schema script 'VW_ST_RESULT_R56b7b40_241
.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
• Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL20164)
Get help: http://help/MSSQL_REPL20164
• Invalid object name 'VW_ST_RESULT_WITH_SAMPLE'
. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208