Post reply

Replication from subscriber to publisher

  • June 29, 2004 at 2:27 am

    #85835

    Hi,

    I would require to replicate data from one SQL server instance (version 7) to another SQl server instance (2000) and vice-versa also.

    Please suggest as to how can I go about this. The data should be updated as often as it can.

    Thanks,

    Yogita

     

  • June 29, 2004 at 6:28 am

    #512395

    There are several ways.

    You can use Merge replication.

    Also Transactional replication with inmediate or queue subscription.

    Or also can set up a transactional publication in the publisher, another transactional in the subscriber (wich now will be another publisher) and use the loopback detection option.

    It will depend of what you really need to do. The easiest, could be a merge publication.

  • June 29, 2004 at 8:03 pm

    #512560

    Thanks racosta. I will try this option. Actually, I am new to replication. I was wondering if linked server thingy can help me with it. I ahve no clue about it at the moment though.

    Basically, I need to insert only partial data of a table from SQL server 7 to a table in remote SQL Server 2000. From the 2000 server, I need to insert data in some other table in SQL server 7.

    Your help will be much appreciated.

    Thanks again,

    Yogita

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply