Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 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.

share|improve this answer
    
I don't really have the option to touch the Sybase Server –  David Osborn Dec 7 '10 at 20:13
    
Last time I worked with Sybase, replication was a separate product –  jl. Dec 7 '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 7 '10 at 21:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.