Post reply

transactional replication?

  • September 5, 2006 at 9:19 am

    #173804

    Hi,

    Does anyone know where I can find information on how to set up a transactional replication step by step?  Any comments would be greatly appreciated.

    Newbie on the block! 

     

  • September 6, 2006 at 6:47 am

    #658719

    http://www.databasejournal.com/features/mssql/article.php/1438201

  • September 6, 2006 at 2:39 pm

    #658888

    Thanks Joe!  I really appreciate it!

     

    Kim

  • September 6, 2006 at 2:48 pm

    #658892

    I have been researching on Transactional and Merge replication for MS SQL 2000 but I have to say it's a bit overwhelmed.  Does anyone out there know any good websites?  Any inputs would greatly appreciate it!

    K

  • September 6, 2006 at 5:07 pm

    #658908

    http://www.replicationanswers.com is a good resource. I havent yet seen any step-by-step guide anywhere. I did a brief to-the-point write up an article on setting up Trans-Rep from a backup copy. If you are interested you can check out my blog.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • September 6, 2006 at 9:39 pm

    #658950

    Thanks Dinakar!  I really appreciate your response!

    Kim

  • September 7, 2006 at 1:49 pm

    #659189

    Hi,

    I am a bit confused in transactional replication, can I do an update, insert, or delete in the subscriber?  or is it a read only database?  If so, is there a way to get around it?  like bi-directional maybe?  and how do you set it up? 

    Does anyone out there know what I am talking about?   🙂

    Please help!

    Thanks,

    newbie on the block!

  • September 11, 2006 at 10:08 am

    #659696

    You could do INSERT/UPDATE/DELETE on subscriber but then your data could be out of sync with your publisher. There is a bi-directional replication in SQL 2005. Its called Peer-Peer Replication. There are clear instructions in BOL on setting it up.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • September 11, 2006 at 10:50 am

    #659711

    Thanks Dinakar!  My company is now interested in setting up Merge replication in SQL Server 2000.  I have the material of how to set it up step by step but I was just wondering where I can find the testing methods, or if you know of any? 

    Any comment would be greatly appreciated!

    newbie...

     

     

  • September 11, 2006 at 3:52 pm

    #659771

    You could find some good info on http://www.replicationanswers.com. There are some good articles on SQLServercentral.com too.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • September 11, 2006 at 4:52 pm

    #659774

    that's awesome!  thank you!

     

     

  • September 12, 2006 at 4:48 pm

    #659989

    Hi,

    I am using SQL Sever 2000 and am trying to configure replication using Merge as the method.  I have two servers, server A (Publisher and Distributor), server B (Subscriber), I followed the wizard to configure publisher, distributor and subscriber but got the error message, it said that "Error 18483: could not connect to 'server A' because 'distributor_admin' is not defined as the remote login at the server".  I am not really sure what I did incorrect but any help would really appreciate it!!!!

    Newbie on the block! 

     

     

Viewing 12 posts - 1 through 11 (of 11 total)

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