1

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?

Zoredache
  • 128,755
  • 40
  • 271
  • 413
ctrlalt313373
  • 211
  • 2
  • 7

1 Answers1

1

SQL Server replication can't use a Sybase table as the publisher. You will need to look into the Sybase replication options. Perhaps you can replicate the data from the Sybase server to the SQL 2008 server, then use SQL Server replication to replicate that data down to the SQL 2008 Express clients.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
  • I don't really have the option to touch the Sybase Server – ctrlalt313373 Dec 07 '10 at 20:13
  • Last time I worked with Sybase, replication was a separate product – jl. Dec 07 '10 at 20:54
  • Without being able to make changes to the Sybase Server you'll need to build something which pulls the data from the Sybase server and loads updated/new data into a table in the main SQL Server, then use replication to push that data down to the Express instances. – mrdenny Dec 07 '10 at 21:39