2

yes, that is possible - you create 3 different publications - and in each publication you add only the respective tables you want for each server. for example - only 2 tables for server1 The other tables will be in other publications, not this one. Alternatively, within the merge replication you can set up filters and each subscriber would see only a ...


2

I don't know if this apply to your issue, but according MS-DOCS about this error: Error number: MSSQL_REPL-2147201001 Maybe it is not about trying to replicate a VIEW before the TABLE, but another reasons. Quoting from docs: (Bold is mine) Explanation COM object initialization failed for an XML Subscriber. Some reasons why merge replication did ...


1

Confirmed. Replication on Linux begins with SQL Server 2019 according to Microsoft SQL Server 2019 introduces SQL Server Replication for instances of SQL Server on Linux.


1

You can add a filter like: 0 = 1, and the article becomes upload only


Only top voted, non community-wiki answers of a minimum length are eligible