Merge Replication for SQL Server 2005

  • Hi! I'll ask for your help. Will somebody teach me or give me manuals or help me find a site that will teach me on how to set up SQL Server 2005 merge replication step by step. I have no idea on how will I do this and I'm having hard time to look for articles or ebook that will guide me.

    Your prompt reply will be greatly appreciated. Thanks.


    Kindest Regards,

    Florence

  • This was removed by the editor as SPAM

  • I've been out searching for the same thing.

    Seems no one cares too much about those starting out and the simple questions.

    If you've found something in the mean time, please let me know.

  • I haven't read all the detail becuase I've been doing this for a while, but the starting point would be in BOL

    ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMMain3/html/288a1701-d3d1-4410-9f3a-9fae0d5638f4.htm

    This is as it relates to SQL Mobile, but it's not clear if that is what you are looking for.

    Off the top of my head, you should least consider the following

    Setup the server as a publisher and distributor (this is a basic scenario as you can actually have them on different machines). (Right click on the Replication node in SQL Server Management Studio)

    Create a publication on the desired database. (Again right click, on local publications)

    Work out ahead of time what data each subscriber requires and how you intend to filter that data. This is critical to the success of merge replication. If you think the same bits of data will be updated at the subscriber as well as the publisher, dig a little deeper. You need to reduce the risk of conflicts in the data.

    You can create local subscriptions to test your synchronisation. There are plenty of wizard interfaces to get yourself going.

    That's not comprehensive by any means, but hopefully will get you started. Remember, BOL is you oracle (can I say that in here?)


    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • Hi,

    I am also in the process of designing a second colo database. That means we are going to use merge replication for colo 1 and colo 2 databases in order for them to be in sync.

    Came across below article regarding Merge Replication step by step guide:

    http://www.codeproject.com/KB/database/sql2005-replication.aspx

    Hope you'll find this useful.

    Amol

    Amol Naik

  • I just learned and there is a very nice synopsis of all types of replication at Database Journal under MS Sql - Sql Server Express Edition (down towards the bottom). A direct link to the starting article posted about a year ago is

    http://www.databasejournal.com/features/mssql/article.php/3719781/SQL-Server-2005-Express-Edition---Part-14---Replication-Support.htm

    The series goes through Part 18 and steps you through each type of replication as well as synchronizing on the web.

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

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