I have a SQL2008 server with a linked Sybase server. I have several tables on the SQL2008 server that I need have merge replicated to some SQL2008 Express clients. I also need to get two tables from the linked Sybase server down to the SQL2008 Express clients. These two tables won't be updated at all on the SQL2008 Express clients, but are just used in a read only fashion to augment information in the other tables. Ideally I would also want to filter data from these two tables using a join filter based on one of the SQL tables that is replicating down.
Is there anyway for me to do this short of creating two corresponding tables in SQLServer 2008 and programatically inserting the rows I need replicated into these two new tables?