Solved

Database Replication and updates

Posted on 1998-09-02
5
221 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

740 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