[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Replication questions

Posted on 2006-04-07
6
Medium Priority
?
224 Views
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?
0
Comment
Question by:mfehrmann
  • 3
5 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 16406434
<<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




0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16406510
also use this to create the triggers at subscriber

sp_script_synctran_commands
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16463302
HI mfehrmann ,
Do you still need assitance?
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 16469254
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.
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16758805
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

834 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