Replication questions

Posted on 2006-04-07
Last Modified: 2006-11-18
Here is my scenario:  I have two sql servers that replication via merge replication every night.  I have 5 clients that point to one server that run a program that modifies the sql data in the tables.  No structural changes just data.  Now I have two clients running MSDE on their laptops and I want them to be able to be able to take their laptops home and be able to make changes to their database and when they come back the data merges on the server and also any changes that were made from the other clients on the server for that data to end up back on the laptop.  

I have them set up now to merge back on the server but the data that they changed when they were at home is not showing up on the other clients that are connected to the server.
What am I doing wrong here?
Question by:mfehrmann
    LVL 28

    Expert Comment

    <<not showing up on the other clients that are connected to the server. >>

    Check the following

    Did you configure replication to be two way or not?
    Is it showing Data changes from the other 3 client to the server?
    Is the data showing from the 2 laptop to the server?

    Are you getting any error or just no data for replication keep it for an hour and see.

    the best way is to delete the replication with the two laptop reconfigure it with the option data and schema already exists and then create the procedures at the subscriber which is the laptop.
    i dont know the exact name for the system procedure to create the triggers and procedure but it is something like
    master.dbo.sp_scriptpublicationcustomprocs @Publication

    run this sp on the publisher and run the result on the subscriber

    LVL 28

    Expert Comment

    also use this to create the triggers at subscriber

    LVL 28

    Expert Comment

    HI mfehrmann ,
    Do you still need assitance?
    LVL 5

    Author Comment

    I just put them back on to merge and I have the merge running twice a day so if the laptops are not connected in the morning that they will synch in the afternoon.  It all seems to be working correctly now.  I really wanted to have the replication live on two of the systems but that was not workiing for some reason.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now