Solved

Database Replication and updates

Posted on 1998-09-02
5
204 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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