Solved

Database Replication and updates

Posted on 1998-09-02
5
217 Views
Last Modified: 2010-03-19
Greetings,
My company has a large SQL Server based app running over a local network. We are in the process of moving some staff to another building. This application needs to be available to a number of people (30) on both sides. The connection for the next few months will be very slow, ie T1.

My solution is to use SQL Server replication with three or four hour intervals. New site as publisher and distributor machine and present site as subscriber, but both sides will be making changes to the same table and possibly records. New site primarily adding new records and present site primarily updating records.

My question is this:

How do I handle the replication so that records entered on the subscription machine are not overwritten with the published data. Is this an SQL server setting or am I going to have to write an sp or something? If an SP or other method is involved a sample would be appreciated.

Thanks,
Brad

0
Comment
Question by:bhummel
  • 3
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
connex earned 100 total points
ID: 1089895
If you want to have always the same datas on both servers the only way is to make bidirectional replication. (Which must be done by hand in 6.5, see the SQL Books for an example)
In 7.0 just make the Distribution a Merged Distribution.

If you need further help with bidirectional Replication contact me via email (us@datapec.datagroup.de), i have set it up quite some times now, and know about a lot of traps in there .)

0
 

Author Comment

by:bhummel
ID: 1089896
Actually what I am going to do is: Use the current server as a Report Server Read-Only and any updates will be done through the new server over the T-1 line. The New Server will then Publish any updates to the Existing Server(Subscriber). This gives us full redundancy on both without the maintenance and coding issues involved with bi-directional replication.

Thanks for your help. If you could e-mail me a real world example that would be great.

Thanks,
Brad
0
 
LVL 2

Expert Comment

by:connex
ID: 1089897
I have implemented exactly that using triggers. I will explain
via email on monday (have to go for a weekendtrip now), as it's a bit lengthy.

0
 
LVL 2

Expert Comment

by:connex
ID: 1089898
Aeh reminds me that i don't have your email yet .)
Just send me a short email that i get your address please

0
 

Author Comment

by:bhummel
ID: 1089899
bhummel@criimi.com.

Thanks for your help
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

685 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