Solved

Database Replication and updates

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
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.
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

861 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

25 Experts available now in Live!

Get 1:1 Help Now