SQL Server 2008 R2
I am a beginner with replication and am trying to run merge replication on an entire database (tables, views, functions, SPs etc).
The snapshot generated OK, I created the subscription OK but cannot "propagate to the subscriber".
I suspect this is because it is trying to send, for want of a better word, the view definition before it has sent the underlying table(s). There are several interdependent views and tables, in the database; how do I resolve this?
Is it a question of several publications with different articles, run in a hierarchical order from the bottom up? Is there a system stored proc that can help me find what object is dependent on which others?
Thanks in advance,