Post reply

Replication from SQL 7 to SQL 2005

  • January 28, 2009 at 3:29 am

    #383818

    Hi,

    Is it possible to do replication from SQL 7.0 (replicator/distributor) the to SQL 2005 server(subscriber)?

    If yes, can anyone let me know how to configure the Transactional replication?

    Thanks in Advance.

  • January 28, 2009 at 3:52 am

    #933688

    yes it's possible to have mssql 2005 as subscriber and mssql 7 as publisher

  • January 28, 2009 at 8:36 am

    #933867

    You won't probably be able to use 7.0 UI tools and the best way to set up the subscriber is going to be with TSQL stored procedures.

    I have not used SQL 2005 UI Tools with SQL 7.0, so I can't say if using 2005 UI is possible or not but you should give that a shot if you don't feel comfortable setting up replication with stored procedures.


    * Noel

  • January 28, 2009 at 8:36 am

    #933868

    There is no difference between how you set up replication between 7 to 7 and 7 to 2005. Configure the Distributor first and then set up the Publisher and distributor. Make sure to keep the Distributor and Subscriber is separate systems in order to avoid IO bottleneck.

    -Roy

  • January 28, 2009 at 8:54 am

    #933883

    Thanks for your reply.

    Can you give me any idea on how to start with SP for replication or any articles on key points to noted on configuring replication between SQL 7 and SQL 2005?

Viewing 5 posts - 1 through 4 (of 4 total)

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