Friday, March 23, 2012

replication between SQL Server database and linked informix server

I need help setting up replication between my SQL Server (data warehouse) database and a linked informix database.
Does anyone know the best to accomplish this. I can provide any additional information you require to help you, help me ;-)SQL Server support replicate between SQL Server and non-SQL Server Database.
U can choose snapshot replication ,transactional replicate and merge replication.
First U must establish a distributor(a SQL Server which is an agent is responsible for transfering data between two database server)
Then u will make SQL Server as a publisher and using the distributor u created to publish your data.
last, make the informix server as the subscriber to retrieve the data from the distributor.|||Also refer to books online about replication, heterogeneous data sources topic.|||Originally posted by Satya
Also refer to books online about replication, heterogeneous data sources topic.

I would like to use Access as the publisher and SQL as the subscriber. When I check BOL and forums... I am not finding anything that explains how I can accomplish this. Please keep in mind, I want to set up transactional replication between Access and SQL.|||I think after enabling Linked server connection to Access you can use Replication wizard as listed in this [http://www.databasejournal.com/features/mssql/article.php/1438201] article.

HTH

No comments:

Post a Comment