Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    31

    Unanswered: 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 ;-)

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also refer to books online about replication, heterogeneous data sources topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Apr 2004
    Posts
    31
    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.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I think after enabling Linked server connection to Access you can use Replication wizard as listed in this [http://www.databasejournal.com/featu...le.php/1438201] article.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •